Heaps of Trouble, Clusters of Glory - A Look At Index Internals
Indexes are a crucial component of SQL Server, especially in performance tuning, yet many DBA's don't fully understand how indexes work. In this in-depth session, Michelle will examine the anatomy of indexes, from how they're stored to how they get fragmented. And to make our inner geeks happy, she'll look at page data to show you what's happening behind the scenes. Topics covered will include index structure, fragmentation and defragmentation, index partitioning, and index filtering. If you've ever wondered just *what* goes on in an index, don't miss this session!
Sr. SQL Server DBA
Michelle Ufford is a Senior SQL Server Developer at GoDaddy.com, the world's largest domain name registrar and web hosting company. She has over a decade of IT experience in a variety of roles, but prefers being a DBA. In her current role, Michelle specializes in designing and tuning high-volume, multi-terabyte databases. She's perhaps best known for her index defrag script and for tuning a VLDB to achieve 27k transactions per second during Super Bowl. Michelle's blog, http://sqlfool.com, was awarded "Best New Blog" & runner-up for "Best BI Blog Post" at the PASS Log Reader Awards at Summit 2009. She has also founded her local PASS chapter, written several SQL Server articles, and presented at numerous events on SQL Server topics.
Register Now for PASS Summit 2010!