dcsimg

Queries Dragging? Try Defragging

June 21, 2007

[From SQL Server Magazine]

Did you ever have a user tell you a query is taking a lot longer to compete than before, even though nothing in it has changed? If so, there's a good chance that the indexes in the table that the query ran against have become fragmented. Fixing this problem is a two-step process. First, you need to first determine which indexes have become fragmented. Second, you need to defrag those indexes.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=96059








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers