Level: Introductory to Intermediate
Curriculum Director for IT Pro Content
Dig deep into SQL Server index tuning. Learn exactly how SQL Server builds, maintains, and uses indexes under the hood, and review best practices for building and maintaining indexes. You’ll also walk through a complete index performance-tuning example using SQL Profiler, giving you a practical scenario that you can put to use as soon as you get home. You’ll learn about all of the ins and outs of indexes, including file placement, read vs. write workload, statistics maintenance, fragmentation and page splits, rebuilding and reorganizing, and much more. If you’re just getting started as a DBA, or need a quick review of index tuning essentials, this is the perfect session for you.