PASS Summit 2010
Register Now

ROI Justification



PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:
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, 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,, 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!

  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!

Gold Sponsor

Copyright 2010 by PASS | Terms of Use | Privacy Statement