Gerard

SQL Server Indexing - a Dot Net User Group presentation

by Gerard on 16. May 2011 14:43

Thursday 12 May, I presented at the Hawke's Bay Dot Net User Group (a group within the NZ MS Communities) on SQL Server Indexing. The idea for this presentation was born after a discussion we had at Red Jungle on a particular application we have created a while ago. After that discussion I thought that it would be a good idea to share some of the knowledge we have built up with working on SQL Server for close to 10 years now and share it with the local community. I had forgotten that it actually takes quite a bit of time collecting all the details of your presentation, making sure you have some good demos and then creating the presentation. But in the end it worked out quite well, and I believe it was helpful for at least a good part of the audience.

The presentation is aimed at the developer audience we have here in the DNUG. I don't expect DBAs to find a lot of new stuff in what I presented. Although you never know of course. But, as we do, modern day developers of smaller software development companies are also the database designers and maintainers, and I believe that every developer who is in that position should at least know what I presented. That will make him a lot better developer for as far as SQL Server is concerned.

I have put most of the content I presented available for download for you below. Feel free to use it in any way that is beneficial to you.

  • The PowerPoint slides itself
  • The tool used to generate test data for the database and running the speed test at the start. Check out the "ReadMe.txt" file for how to use it.
  • The SQL scripts for the five demos referred to in the PowerPoint slides

There are a whole lot of additional resources available on this topic. I have listed some of them here. Most of these were used as inspiration for this presentation. I can highly recommend the videos from SQL Skills. They are very useful.

On the physical structure of Indexes:

On Optimizing indexes and finding the right indexes

General sites: