I have indexes, but do I have the right indexes?

Do you have all the right indexes on your SQL Server databases? Have you implemented any indexes other than traditional clustered and non-clustered indexes? If the answer to either question is a “no” or an “I don’t know”, then this session is for you.

This session will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!

Are you using a version and edition of SQL Server is able to use these features? We’ll cover that too and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.

Eric Blinn has been a SQL Server DBA in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.

Eric is a[masked] Idera Ace and has co-authored 2 Idera Whitepapers.

He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.