Which index need to rebuild / re-organize

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Which index need to rebuild / re-organize

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-07-23 : 10:28:31

Hi,

Did anyone have a script to show 'Which index need to rebuild / re-organize'

If yes, hopefully someone can share with me

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-07-23 : 10:36:00

Check out Ola Hallengren's Index maintenance script: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

If you pass 'N' to the @Execute parameter it will generate a list of indexes to be processed based on the other settings you pass. This is the easiest and best procedure to use for index maintenance.

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-07-23 : 10:37:41

tq sir

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-23 : 14:44:57

I personally prefer Tara Kizer stored procedure for this purpose
http://weblogs.sqlteam.com/tarad/archive/2007/04/17/60176.aspx

--------------------------
http://connectsql.blogspot.com/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-23 : 14:56:08

If you're going to use mine, here's the most recent published version: http://weblogs.sqlteam.com/tarad/archive/2009/11/03/DefragmentingRebuilding-Indexes-in-SQL-Server-2005-and-2008Again.aspx

I do have a newer version though, just haven't published it to my blog yet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-23 : 15:03:15

Thanks for correcting me, just updated (newer link) on my blog post http://connectsql.blogspot.com/2011/01/sql-server-simple-method-to-resolve-all.html

Tara please publish latest, if tested and found good to go.

--------------------------
http://connectsql.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources