SQL Server Performance Tuning and Optimization

SQH02 Indexes - The Unsung Heroes of SQL Server 2014


8:00am - 9:15am

Level: Intermediate to Advanced

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

Slow Running Queries are the most common problem that developers face while working with SQL Server. While it's easy to blame SQL Server for unsatisfactory performance, the issue often persists with the way queries are written and how Indexes are set up. The session will focus on the ways of identifying problems that slow down SQL Server and Indexing tricks to fix them. There will be a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

You will learn:

  • SQL Server 2014 has introduced an updatable column store index. We will have story built around columnstore indexes (usage, needs, limitation and advantages)
  • A crash course of indexes in very first few minutes of the session which will cover all the basics like excessive indexes, missing indexes, unused indexes, etc.
  • SQL Server 2014 has new feature of in-memory tables. Lots of DBA's and developers do not know how indexes work along with in-memory tables. In this session we will clear the idea