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 2000 Forums
 SQL Server Administration (2000)
 Reindexing..

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-11 : 09:29:29
jayant writes "hello Guys,

I am working on SQL 2000 for more than 1.5 yrs as programmer.
I dont know much abt server side administration like backups & perforamnce tuning..

I am supposed to reindex the database to excel performance.
Can anybody tell me whtas the optimum sacn denstity that is eligibel for reindexing a table..
what are the other criterias to be considered..?


can u suggest me any study articels on the same..!


jayant"

Kristen
Test

22859 Posts

Posted - 2006-04-11 : 09:54:59
Microsoft have a white paper on this. Sorry, I don't have a link to hand but I have a feeling that Paul Randall wrote it.

Kristen
Go to Top of Page

bakerjon
Posting Yak Master

145 Posts

Posted - 2006-04-11 : 13:35:01
Here is a nice article my Mike Ruthruff of the CAT group.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx


Jon

Holding it down on the engineering tip, y'all!

http://www.sqljunkies.com/weblog/outerjoin
Go to Top of Page
   

- Advertisement -