Yes it still exists and the code is available for customization. 2005
has a neat feature that allows alter index on the fly. (Enterprise
keeps the old index up while reindexing.) An advantage of this approach
is that the index is defragged as well. I use sp_MSforeachdb to reindex
and defrag all of the databases. Use caution if you do not have the
enterprise edition because the table being reindexed will be out of
commission until complete. I have code to create a stored proc. If
interested, write me for a copy.
John Lull, HS DBA
-----Original Message-----
From: MILIND AMIN /TECPRO/L-PAREL
[mailto:mssqldba-ezmlmshield-x76762458.[Email address protected]
Sent: Friday, December 29, 2006 9:40 AM
To: LazyDBA Discussion
Subject: RE: Rebuilding all indexes on all table
SAME TO YOU.
Regards,
Milind Amin
Software Professional
TechProcess Solution Ltd
Direct: +91-22-66528612 (M-F Firstly)
Cell: +91-9819916106 (M-S Secondly)
------------------------------------
TEAMWORK...
Coming together is a beginning;
Keeping together is progress;
Working together is a success;
-------------------------------------
-----Original Message-----
From: BOUCHE Sylvain GBM
[mailto:mssqldba-ezmlmshield-x39070719.[Email address protected]
om]
Sent: Friday, December 29, 2006 9:01 PM
To: LazyDBA Discussion
Subject: RE: Rebuilding all indexes on all table
Still exists in 2005.
Thanks everybody and happy new year to all.
-----Original Message-----
From: Markiewicz Christopher
[mailto:mssqldba-ezmlmshield-x97808461.[Email address
protected]
Sent: 29 December 2006 15:11
To: LazyDBA Discussion
Subject: RE: Rebuilding all indexes on all table
This method uses an undocumented system proc. It works for
SQL Sever 2000,
but I'm not sure if this undocumented proc exists in SQL
Server
2005:
use <your dbname>
go
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX
('?')"
Go
- Chris
-----Original Message-----
From: BOUCHE Sylvain GBM
[mailto:mssqldba-ezmlmshield-x77013264.[Email address
protected]
Sent: Friday, December 29, 2006 9:45 AM
To: LazyDBA Discussion
Subject: Rebuilding all indexes on all table
Hi,
Has anybody got a script for rebuiling all indexes on all
tables in a
specified db using the ALTER INDEX statement?
Thanks,
Sylvain
************************************************************
************
***********
The Royal Bank of Scotland plc. Registered in Scotland No
90312.
Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB.
Authorised and regulated by the Financial Services Authority
This e-mail message is confidential and for use by the
addressee only.
If the message is received by anyone other than the
addressee, please return
the message to the sender by replying to it and then delete
the message from
your computer. Internet e-mails are not necessarily secure.
The Royal Bank of Scotland plc does not accept
responsibility for changes
made to this message after it was sent.
Whilst all reasonable care has been taken to avoid the
transmission of
viruses, it is the responsibility of the recipient to ensure
that the onward
transmission, opening or use of this message and any
attachments will not
adversely affect its systems or data. No responsibility is
accepted by The
Royal Bank of Scotland plc in this regard and the recipient
should carry out
such virus and other checks as it considers appropriate.
Visit our websites at:
www.rbs.com
www.rbsgc.com
www.rbsmarkets.com
************************************************************
************
***********
------------------------------------------------------------
---------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
REPLY To post a dba
job: http://jobs.lazydba.com To subscribe :
http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
This e-mail may contain confidential or privileged
information. If you think
you have received this e-mail in error, please advise the
sender by reply
e-mail and then delete this e-mail immediately.
Thank you. Aetna
------------------------------------------------------------
---------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
REPLY To post a dba
job: http://jobs.lazydba.com To subscribe :
http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
------------------------------------------------------------
---------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
"This e-mail message may contain confidential, proprietary or legally
privileged information. It
should not be used by anyone who is not the original intended recipient.
If you have erroneously
received this message, please delete it immediately and notify the
sender. The recipient
acknowledges that ICICI Bank or its subsidiaries and associated
companies, (collectively "ICICI
Group"), are unable to exercise control or ensure or guarantee the
integrity of/over the contents of the information contained in e-mail
transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no
binding nature of the message shall be implied or assumed unless the
sender does so expressly with due authority of ICICI Group.Before
opening any attachments please check them for viruses and defects."
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page