<div>
And here is a pretty good article with many useful links about SQL Indexes:<br />
<br />
<a href="http://blogs.technet.com/b/josebda/archive/2009/03/17/indexing-best-practices-for-sql-server-2008.aspx" rel="ugc">http://blogs.technet.com/b/josebda/archive/2009/03/17/indexing-best-practices-for-sql-server-2008.aspx</a>
</div>


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 [http://blogs.technet.com/b/josebda/archive/2009/03/17/indexing-best-practices-for-sql-server-2008.aspx]

<div>
That is what I thought, thank you for the verification.
</div>


That is what I thought, thank you for the verification.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Any URLs on this topic would be great...Thanks!
</div>
</div>


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!

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.