Tuesday, March 20, 2012

Rebuild

What would be the best way for every day maintainance like
Should I rebuild all the indexes every day or rebuild the statistics every
day?
Thanks in advance.
Ideally would be when your database is not in use because rebuilding indexes
can cause lock contention.
A good resource is the following web page: "Tips on Rebuilding SQL Server
Indexes " http://www.sql-server-performance.co...ng_indexes.asp
Cristian Lefter, SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:28CA996E-B854-40C3-9547-8FD38B7AB68B@.microsoft.com...
> What would be the best way for every day maintainance like
> Should I rebuild all the indexes every day or rebuild the statistics every
> day?
> Thanks in advance.

No comments:

Post a Comment