sp_MSforeachtable
in [Programming SQL]
|
Prev: AdventureWorks database
Next: using output
From: Bob McClellan on 10 Nov 2009 22:32 Is sp_MSforeachtable the best approach to maintain the rebuilding of all indexes for all tables in a database? thanks in advance, ...bob
From: Balaji on 11 Nov 2009 00:00 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" <bobmcc(a)tricolift.RemoveThis.com> wrote in message news:04C118AA-314D-47BA-AC3E-72F1676AB8CE(a)microsoft.com... > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob
From: Uri Dimant on 11 Nov 2009 03:30 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 Read the link http://ola.hallengren.com/ "Bob McClellan" <bobmcc(a)tricolift.RemoveThis.com> wrote in message news:04C118AA-314D-47BA-AC3E-72F1676AB8CE(a)microsoft.com... > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob
From: Bob McClellan on 11 Nov 2009 13:04 Thanks to both of you. I really appreciate the reply and advice against moving forward with this. ...bob "Bob McClellan" <bobmcc(a)tricolift.RemoveThis.com> wrote in message news:04C118AA-314D-47BA-AC3E-72F1676AB8CE(a)microsoft.com... > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob
From: Bob on 12 Nov 2009 05:59
A Maintenance plan is probably your best option. "Bob McClellan" wrote: > Thanks to both of you. I really appreciate the reply > and advice against moving forward with this. > ..bob > > > "Bob McClellan" <bobmcc(a)tricolift.RemoveThis.com> wrote in message > news:04C118AA-314D-47BA-AC3E-72F1676AB8CE(a)microsoft.com... > > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > > indexes > > for all tables in a database? > > thanks in advance, > > ..bob > |