Introduction to Indexes and SARGability
Did you know that there is more than one type of index? Do you know the differences between them? Do you know when SQL Server flat out can’t use an index? Join Jared Karney as he explains the differences between the types of indexes and when they can and cannot be used (SARGability). He will talk about the different ways they are used and how you can make good indexes even better. You will leave this session understanding the basics of indexes and how they work, which is crucial to making your queries and servers perform well.
Jared Karney has been a SQL Server DBA since 2007 and was a Business Analyst and SQL Developer before that. He currently works as a Premier Field Engineer for Microsoft. His interests include performance tuning, automation, internals, and overall architecture.
up