Recently I just wrote a blog post on about Learning SQL Server Performance: Indexing Basics and I received lots of request that if we can share some insight into the course.
Here is 200 seconds interview of Vinod Kumar I took right after completing the course. We have few free codes to watch the course, please your comment at http://facebook.com/SQLAuth and we will few of first ones, we will send the code.
There are many people who said they would like to read the transcript of the video. Here I have generated the same.
Pinal: Vinod, we recently released this course, SQL Server Indexing. It is about performance tuning. So tell me – how do indexes help performance?
Vinod: I think what happens in the industry when it comes to performance is that developers and DBAs look at indexes first. So that’s the first step for any performance tuning exercise, indexing is one of the most critical aspects and it is important to learn it the right way.
Pinal: Correct. So what you mean to say is that if you know indexing you can pretty much tune any server and query.
Vinod: So I might contradict my false statement now. Indexing is usually a stepping stone but it does not lead you to the end. But it’s good to start with indexing and there are lots of nuances to indexing that you need to understand, like how SQL uses indexing and how performance can improve because of the strategies that you have made.
Pinal: But now I’m confused. First you said indexes are good, and then you said that indexes can degrade your performance. So what is this course about? I mean how does this course really make an impact?
Vinod: Ok -so from the course perspective, what we are trying to do is give you a capsule which gives you a good start. Every journey needs a beginning, you need that first step. This course is that first step in understanding.
This is the most basic, fundamental course that we have tried to attack. This is the fundamentals of indexing, some of the key things that you must know about indexing. Some of the basics of indexing are lesser known and so I think this course is geared towards each and every one of you out there who wants to understand little bit more about indexing.
Pinal: So what I understand is that if I enrolled in this course I will have a minimum understanding about indexing when dealing with performance tuning. Right?
Vinod: Exactly. In this course is we have tried to give you a nice summary. We are talking about clustered indexing, non clustered indexing, too many indexes, too few indexes, over indexing, under indexing, duplicate indexing, columns tune indexing, with SQL Server 2012. There’s lot’s to learn.
Pinal: You can see the URL [http://bit.ly/sql-index] of the course on the screen. Go ahead, attend, and let us know what you think about it. Thank you.
Vinod: Thank you.
Reference: Pinal Dave (http://blog.sqlauthority.com)