X-Ray Glasses for Your SQL Server Indexes
You've read the best practices on how to define indexes in SQL Server. You're ready to learn why those best practices exist, and how you can tell when it's appropriate to break one or two of the rules. Microsoft Certified Master Kendra Little will show you what's hard to see in the built-in SQL Server tools: the complex relationship between clustered and non-clustered indexes. Kendra will demonstrate how to estimate the overall performance cost of different column choices for a clustered index. She'll give you free scripts to identify problems with index definitions in existing databases, and a decision tree to help you decide when it's worth it to make a change. This session is for developers and DBAs with one year or more of experience defining schema in SQL Server.
Kendra Little helps people make SQL Server faster, more reliable, and easier to manage. She is a Microsoft Certified Master in SQL Server and a Microsoft MVP. Kendra draws free posters about her adventures with databases-- check them out at http://www.brentozar.com/first-aid