Super Smart Universal Reindexing script supporting SQL 2005 onwards
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Scripts
README.md
Re-Indexing - The quest of ultimate automation.pptx
SmartReindexing - The quest of ultimate automation.docx

README.md

SmartReindexing

Super Smart Universal Reindexing script supporting SQL 2005 onwards

SmartReindexing.ps1 - Script to run from local or network computer

SmartReindexing_TestJob.sql - Test job to schedule reindexing job

Full Video explaining script: (this is for V 1.0)

https://www.youtube.com/watch?v=rTJhJy51BIE&feature=youtu.be

License: The SQL Server Maintenance Solution is free.

Destinctive Features:

Reindex only fragmented tables

Takes log backups in between to ensure logfile do not get filled up

Timeout automatically based on table size to avoid long blockings created by Index jobs

Automatically update fill factor to 90 if not specified for tables with fragmentation

Detailed execution status is logged into msdb..tbl_indexRebuild_Log

Check SmartReindexing - The quest of ultimate automation.docx for usage details