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 2005 Forums
 Transact-SQL (2005)
 rebuld index

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2011-08-05 : 01:33:31
Hi All,
I need a small help as i want to rebuild an index for a specific data base,what is the query?

Thanks in Advance.

Sachin.Nand

2937 Posts

Posted - 2011-08-05 : 05:19:34
All the indexes in a database or a specific index?

PBUH

Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2011-08-05 : 06:08:29
only for few selected databases i want to config rebuld index.
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-08-05 : 06:36:38
Start reading here:
http://weblogs.sqlteam.com/tarad/archive/2009/08/31/DefragmentingRebuilding-Indexes-in-SQL-server-2005-and-2008.aspx

Download Tara's awesome alter index script here : http://www.tarakizer.com/files/scripts/isp_ALTER_INDEX_08312009.zip

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page
   

- Advertisement -