[Video] Fragmentation Explained in 20 Minutes at SQLBits
22 Comments
What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it? At the SQLBits conference, I tried a new way of explaining it using markers and pieces of whiteboard paper as database pages, and doing inserts live on the fly. What you see…
Read More