Tools › Index rebuild script

T-SQL index reorganize / rebuild automation

Pick the thresholds the shop already agreed. We write the DMV loop. Read it before you schedule it on production.

Reorganize if fragmentation ≥ Rebuild if fragmentation ≥ Min page count

Prefer ONLINE = ON (Enterprise) Schema filter

Online rebuilds need Enterprise (or a newer SKU that allows it). This is a draft, not Ola Hallengren’s suite. Test on a copy.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.