When you decide to rebuild or reorganzie an index, you have an option to set something called FILLFACTOR. This is probably the MOST IMPORTANT thing to understand about index maintenance and reducing fragmentation (especially in databases that are prone to it). Unfortunately, we need to dive into some internals to really understand why this is [...]
Kimberly L. Tripp
Improving my SQL skills through your questions!
Database Maintenance Best Practices Part II – Setting FILLFACTOR
Posted on: March 13, 2009 9:45 am
Sounds like Fillfactor…
Posted on: June 19, 2004 1:18 am
The new Seattle Public Library opened on May 23, 2004 and it's an interesting structure that people seem to love or hate. I've always loved architecture (and I really wanted to be an architect when I was growing up :)) so more than anything I just wanted to learn more about the structure. I didn't [...]
