SQL Server Indexes are not always as much as helpful as we like to think. Often they work against our overall server performance. In this session, we will see some troublemaking scenarios and their workarounds. 

Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame SQL Server for unsatisfactory performance, the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will see a few different scenarios where indexes will actually negatively affect the performance of queries. By removing some of the indexes, we can easily improve the performance of overall system. 

This is a very unique session and will explore the dark side of indexes and its resolutions. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. 

The video is not available to view online.