Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
