This isn’t your typical presentation on Index Maintenance.
In this 1st of two back-to-back sessions, we'll learn how the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory/disk space, costly/continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance and how it all negatively impacts your code even if it’s perfect code.
We'll also discover the true costs of page splits, how REORGANIZE can perpetuate them, their effect on performance, introduce and learn how to use "sp_IndexDNA" to see indexes as you've never seen them before, and introduce methods to make even active GUID-based indexes 100% fragmentation free for months at a time, which will also fix the problems we’ve discovered.
This 1st session is also a recommended segue into the second session.
No material found.