Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Had to reindex
Message
 
 
To
12/05/2011 23:25:26
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Title:
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01510533
Message ID:
01510536
Views:
51
>>Do you have a maintenance plan to re-build indexes (de-fragment)?
>
>Only in manual, such as I just did when I went into the application, in the administration interface, and click on the specific index to generate the script.

Try setting it up as a job based on the Michelle Ufford's script or Olla's script. So, it will automatically detect problematic indexes and re-build them as needed.

BTW, I'm reading right now (finished) this blog post
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/sql-server-dba-tip-missing-index-dmv

and it has a link to another interesting post (even if I don't remember it) by Brad Schulz.

Take a look.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform