Solved

When would I need to do maintenance on a clustered index in SQL server

Posted on 2013-01-15
3
217 Views
Last Modified: 2013-01-15
I am looking into creating some index maintenance jobs, and I am wondering when I would ever need to do maintenance on the clustered index. My understanding is that the data is stored with this index and physically ordered by the index. Most of the clustered indexes on the system are PK identity INT.

Any URLs on this topic would be great...Thanks!
0
Comment
Question by:sqlagent007
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
Nevere - unless you have huge available space and can't get rid of it other than by dropping the clustered index then re-create it.
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
And here is a pretty good article with many useful links about SQL Indexes:

http://blogs.technet.com/b/josebda/archive/2009/03/17/indexing-best-practices-for-sql-server-2008.aspx
0
 
LVL 1

Author Closing Comment

by:sqlagent007
Comment Utility
That is what I thought, thank you for the verification.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now