Rebuild vs Reorganize

A Self-Tuning Fill Factor Technique for SQL Server – Part 1

Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

Rebuild index selectively

Rebuild index is expensive most time. So you don't rebuild all index blindly.

SQL 2005 Rebuild\Reorganize Indexes with Reports

This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.