Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sp_MSforeachtable
0 views
Skip to first unread message
Bob McClellan
Nov 10, 2009, 10:32:48 PM11/10/09
to
Is sp_MSforeachtable the best approach to maintain the rebuilding of all
indexes
for all tables in a database?
thanks in advance,
..bob
indexes
for all tables in a database?
thanks in advance,
..bob
Balaji
Nov 11, 2009, 12:00:45 AM11/11/09
to
Hi Bob,
sp_MSforeachtable stored procedure is a undocumented stored procedure. It is
always best to avoid any undocumented procedure in a production
environement.
Regards, Balaji
"Bob McClellan" <bob...@tricolift.RemoveThis.com> wrote in message
news:04C118AA-314D-47BA...@microsoft.com...
Uri Dimant
Nov 11, 2009, 3:30:22 AM11/11/09
to
No Bob , definetely No. Because you need rebuild/reorganize only fragmented
indexes and in most cases I have seen you will need to update statistics
to speed up the query
indexes and in most cases I have seen you will need to update statistics
to speed up the query
Read the link
http://ola.hallengren.com/
"Bob McClellan" <bob...@tricolift.RemoveThis.com> wrote in message
news:04C118AA-314D-47BA...@microsoft.com...
Bob McClellan
Nov 11, 2009, 1:04:49 PM11/11/09
to
Thanks to both of you. I really appreciate the reply
and advice against moving forward with this.
..bob
and advice against moving forward with this.
..bob
"Bob McClellan" <bob...@tricolift.RemoveThis.com> wrote in message
news:04C118AA-314D-47BA...@microsoft.com...
Bob
Nov 12, 2009, 5:59:02 AM11/12/09
to
A Maintenance plan is probably your best option.
Bob Barrows
Nov 12, 2009, 10:32:18 AM11/12/09
to
Why?
Not that I disagree, but readers would likely appreciate having more to
base the decision as to whether to accept your advice than the fact that
they like your name. :-)
Not that I disagree, but readers would likely appreciate having more to
base the decision as to whether to accept your advice than the fact that
they like your name. :-)
--
HTH,
Bob Barrows
0 new messages