March 26, 2014 at 8:32 am
Can anyone recommend some really solid reindexing/defragmentation routines out there?
Thanks in advance.
March 26, 2014 at 9:13 am
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
That is probably the most common on the net today.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 26, 2014 at 2:30 pm
cyanes (3/26/2014)
Can anyone recommend some really solid reindexing/defragmentation routines out there?Thanks in advance.
Ola Hallengren scripts are the best ones out there. http://ola.hallengren.com/
Someone may recommend scripts from Michelle Ufford http://sqlfool.com/2011/06/index-defrag-script-v4-1/
--
SQLBuddy
March 26, 2014 at 4:46 pm
Ola and Michelle. Anything else is a waste of time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply