The Truth about Index Fragmentation
What SQL Server doesn't reveal? Every DBA knows that index fragmentation is bad for performance and Indexes need to be rebuilt from time to time – that's basic maintenance knowledge. But how many of us know that index rebuild might cause degradation in performance? This incredible insight has revealed that rebuilding indexes is not enough for eliminating fragmentation. In this session we will deep dive into the core
structure of data files and understand the difference between physical and logical fragmentation. Additionally, we will reveal why SQL Server's fragmentation counter is misleading. A new methodology will be shown to truly eliminate fragmentation and eventually boost the whole system performance.
Sorry, there are no downloads available for this session.
Noam is a technology expert and a SQL Server guru. With over 10 years of experience in various technologies, he enjoys a wide knowledge range, from Visual C#, .Net, C++, MFC, COM and VB, through UNIX and Oracle and up to a deep and thorough understanding of SQL Server. In his work, Noam deals on a daily basis with a broad and varied clientele, designing, developing and troubleshooting their SQL Server systems. Noam also spends part of his career teaching SQL Server and frequently speaks at events such as the Israeli SQL Server User Group.
The video is not available to view online.