Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...
Cross posting from other blog - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/13/3502.aspx fyi. Hope you don't want to do it!