Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos

Overview

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.

Syllabus

Introduction
Welcome
Session Title
Agenda
Disclaimer
SQL Server Management Studio
First Demo
Execution Plan
Auto Update Statistics
Auto Update Old Statistics
Why Statistics are Important
How Many Indexes
Why 10DB
Index Consumption
Execution Plan Demo
Walk Table Analysis
Update Statistics
Second Index
SQL Server Optimization
Second Try Index
Second Try Index Demo