My photo
Auckland, New Zealand
Smurf sized geeky person with a penchant for IT, gaming, music and books. Half of industrial duo 'the craze jones'. Loves data, learning new things, teaching new things and being enthusiastic.

Wednesday, 22 July 2009

SQL Performance - Index Defragging

I'm in the process of putting together a couple of short talks for the Auckland SQL Server user group meeting in August.

The first presentation is already available to download on the right hand side of the blog page; as soon as the second part is finished I'll post a link to that as well. Code will be included with the presentations so that you can try this stuff out for yourself.

Part I - Defragging Indexes For Beginners
Indexes over time become fragmented and as a result don’t work quite as well as they should. This short talk will show you how to fragment and then fix an index.

Part II - Effective Indexes For Beginners
Use a DMV to identify which indexes are effective and which can be disabled/deleted. This short talk will show you how and why you should be checking the effectiveness of your indexes.




No comments: