Slow Table in SQL Server? Re-Index it!

Posted At : June 18, 2008 7:30 AM | Posted By : Steve
Related Categories: SQL

One of my sites has started getting sluggish lately. I thought it was just that the traffic was increasing and so I should optimize my code. Then, in the last couple of weeks, I had a 3AM scheduled task crash a few times. This weekend, I had a simple query with one row and one column take several minutes to execute even from the SQL Server Query Analyzer. This is getting weird!

[More]

Comments (3) | Print | del.icio.us | Digg It! | Linking Blogs | 32031 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
this sort of things can also be done by creating a database maintenance plan.
# Posted By dfguy | 6/19/08 5:02 AM
Yes, that is the normal setup. We double checked the plan and the option to reindex was not selected, but it is now!
# Posted By Tim Jackson | 6/22/08 7:47 AM
Oh yes this is a revelation to figure this out. I had the same experiences a year ago :)

I found out some other stuff helping me with some of my very large tables. You can see that on my blog: http://sqlgott.blogspot.com
# Posted By SQLGott | 9/29/11 1:56 AM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.