The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Sign in to Subscribe

Meeting Details

The Truth about Index Fragmentation

Thu, Nov 20 2014 19:00 UTC

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.


Noam Brezis

Noam Brezis is a senior SQL Server Consultant at Madeira SQL Server Services in Israel. With over 10 years of experience in the Hitech field, he enjoys a wide knowledge range from Visual C#, .Net, C++, MFC, COM and VB, through Unix, Oracle, and up to a deep and thorough understanding of MS SQL. In his work, Noam deals on a daily basis with a broad clientele such as banks, universities, large scale companies and start-ups, designing, developing and troubleshooting their SQL Server systems. Noam also performs as one of the main teachers of the Technion- Israel Institute of Technology's SQL Server DBA program, besides him being a course developer and conductor for the ongoing business

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids