Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Recommendations for some solid reindexing/defragmentation routines out there... Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 8:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:48 PM
Points: 4, Visits: 62
Can anyone recommend some really solid reindexing/defragmentation routines out there?

Thanks in advance.
Post #1554990
Posted Wednesday, March 26, 2014 9:13 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 21,638, Visits: 15,305
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1555032
Posted Wednesday, March 26, 2014 2:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 11:19 AM
Points: 1,194, Visits: 2,215
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
Post #1555164
Posted Wednesday, March 26, 2014 4:46 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:58 AM
Points: 15,659, Visits: 28,045
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1555213
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse