February 4, 2012 at 8:43 am
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
February 4, 2012 at 9:41 am
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
February 4, 2012 at 9:36 pm
GilaMonster (2/4/2012)
Don't reinvent the wheel...http://sqlfool.com/2011/06/index-defrag-script-v4-1/
or
I very much prefer Ola's.
February 5, 2012 at 3:11 am
February 5, 2012 at 1:22 pm
johnitech.itech (2/5/2012)
Ok pls show m y below Link plsok 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
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply