Blogs

Browse by Tags

• Programming

• Smart Index Defragmentation for an ONLINE World

  One of the many reasons I why I love consulting is the constant evolution and challenge. You may have something that works “just fine” until a new customer simple states “This is great. Can you make it do XYZ too?” I love those “could you just” statements, Read More... Posted Monday, July 30, 2007 8:48 AM by Lara Rubbelke | 2 Comments Filed under: Maintenance Attachment(s): RebuildIndex_SmartOnline.zip

• Smart Index Defrag/Reindex for a Consolidated SQL Server 2005 Environment

  (Update: An ONLINE version of this procedure is now available) I am sure we all have our own version of a "smart" reindex script for SQL Server 2000. This is a script that assesses the current level of fragmentation, and only executes a reindex or indexdefrag Read More... Posted Wednesday, August 16, 2006 10:15 PM by Lara Rubbelke | 32 Comments Filed under: Programming, Maintenance Attachment(s): RebuildIndex_Smart_Update.zip