Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos

Explore the dark side of SQL Server indexes in this 58-minute conference talk from PASS Data Community Summit. Discover how indexes can sometimes hinder server performance and learn effective troubleshooting techniques. Delve into common scenarios where indexes negatively impact query performance and gain practical insights on improving overall system efficiency. Walk away with immediately applicable scripts and knowledge to optimize your SQL Server, including strategies for identifying performance bottlenecks, index management tricks, and when to consider removing indexes for better results. Examine real-world examples through demos covering execution plans, statistics management, and index consumption analysis.