SQL Server Administration and Maintenance

SQH04 Indexes - The Good, Bad and Ugly


9:30am - 10:45am

Level: Intermediate

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

Slow Running Queries are the most common problem you face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, the issue often persists with the way you write queries and set up Indexes. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will have a quiz during the session to keep the conversation alive. You'll walk out with scripts and knowledge you can apply to your servers immediately after the session.

You will learn:

  • About SQL Server 2014's updatable column store index (usage, needs, limitation and advantages)
  • The basics like excessive indexes, missing indexes, and unused indexes
  • How indexes work along with in-memory tables