Solved

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

Posted on 2013-01-15
3
224 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
ID: 38779637
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
ID: 38779645
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
ID: 38779717
That is what I thought, thank you for the verification.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Inner Join - Multiple Join Parameters 2 32
Challenging SQL Update 5 41
Count with a subquery showing details 10 44
SQL Insert parts by customer 12 33
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 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