rebuilding indexes

Question

Post reply

rebuilding indexes

Sarsoura

Ten Centuries

Points: 1220
More actions
February 4, 2012 at 8:43 am

#252312

I am using many indexes in my database
I understood that it is not advisable to rebuild all the indexes at the same time for memory issue
I have a table with a primary key that is referenced by foreign keys in several other tables
is there a recommendation of the sequence of selecting the indexes to be rebuilt in
i.e if I started with the one that is referenced the most would that cause an issue.
another question my database is the back end of a web site if I ran the rebuild index that means users will not be able to access this table
Does that mean I should take the site down during building the indexes.
Thank

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Don't reinvent the wheel...

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

or

http://ola.hallengren.com/Versions.html

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Paul White SSC Guru Points: 150467 More actions · Answer 2

GilaMonster (2/4/2012)
Don't reinvent the wheel...
http://sqlfool.com/2011/06/index-defrag-script-v4-1/
or
http://ola.hallengren.com/Versions.html

I very much prefer Ola's.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 3

Ok pls show m y below Link pls

ok check this link below

http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/[/url]

😉

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 4

johnitech.itech (2/5/2012)
Ok pls show m y below Link pls
ok check this link below
http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/[/url]
😉

The link doesn't work as is.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)