?
Solved

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

Posted on 2013-01-15
3
Medium Priority
?
227 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 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 40

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

741 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