24 Hours of PASS: Summit 2017 Preview

Why Did My Clever Index Change Backfire? (Preview)

Speaker: Kendra Little

Duration: 60 minutes

Track: Build

SQL Server is full of advanced techniques to build powerful indexes: indexed views, filtered indexes, columnstore indexes, and more. But many of these techniques have risks: your cool indexing idea may backfire and leave your users frustrated. In this preview session, you'll see a few demos of how different indexing patterns may slow down queries, have dangerous side effects, or not work at all. If you have a solid knowledge of index basics and are comfortable reading query execution plans, this session will improve your index tuning skills.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

Kendra Little
SQL Workbooks, LLC

Kendra Little teaches people to architect and tune SQL Server for performance. She is a Microsoft Certified Master in SQL Server, a Microsoft MVP, and one of the few artists in the world to draw both... View More

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids