Efficient Index Rebuilding

What's the most effective way to re-index tables without using the Index
Tuning Wizard? I have a large collection of tables (200 or so, only 30 of
which have a large amount of data)whose indices I need to update relatively
quickly, and I do not have a trace file to work off of.
I'm considering removing the PK attributes on these tables, then reassigning
them (which should rebuild them if I am not mistaken).
Any tips would be appreciated. Thanks.THE ITW is not meant for index maintenance. Check out DBCC DBREINDEX and
DBCC INDEXDEFRAG in BooksOnLine.
Andrew J. Kelly SQL MVP
"Elliot M. Rodriguez" <noemail> wrote in message
news:eoGIxSgEEHA.2988@.TK2MSFTNGP12.phx.gbl...
> What's the most effective way to re-index tables without using the Index
> Tuning Wizard? I have a large collection of tables (200 or so, only 30 of
> which have a large amount of data)whose indices I need to update
relatively
> quickly, and I do not have a trace file to work off of.
> I'm considering removing the PK attributes on these tables, then
reassigning
> them (which should rebuild them if I am not mistaken).
> Any tips would be appreciated. Thanks.
>|||Good source of info here too:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Regards
Ray Mond
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:OeGSGZhEEHA.2076@.TK2MSFTNGP09.phx.gbl...
> THE ITW is not meant for index maintenance. Check out DBCC DBREINDEX and
> DBCC INDEXDEFRAG in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
>
> "Elliot M. Rodriguez" <noemail> wrote in message
> news:eoGIxSgEEHA.2988@.TK2MSFTNGP12.phx.gbl...
of
> relatively
> reassigning
>|||I appreciate your help guys... thank you!
"Ray Mond" <yeohray@.hotmail.com> wrote in message
news:eBCoWyhEEHA.3064@.tk2msftngp13.phx.gbl...
> Good source of info here too:
>
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
> --
> Regards
> Ray Mond
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:OeGSGZhEEHA.2076@.TK2MSFTNGP09.phx.gbl...
and
Index
> of
>|||"Elliot M. Rodriguez" <noemail> wrote in message
news:eoGIxSgEEHA.2988@.TK2MSFTNGP12.phx.gbl...
> What's the most effective way to re-index tables without using the Index
> Tuning Wizard? I have a large collection of tables (200 or so, only 30 of
> which have a large amount of data)whose indices I need to update
relatively
> quickly, and I do not have a trace file to work off of.
> I'm considering removing the PK attributes on these tables, then
reassigning
> them (which should rebuild them if I am not mistaken).
> Any tips would be appreciated. Thanks.
script the CREATE INDEX commands, but add WITH EXISTING to it. This
effectively rebuilds the index without having to drop it first
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004