http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspxQuestion: How can SQL Server 2005 help me evaluate and manage indexes? (1) How can I find out whether my indexes are useful? How are they used? (2) Do I have any tables or indexes that are not used (or rarely) (3) What is the cost of index maintenanceen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#532005Tue, 14 Feb 2006 22:50:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:532005Professional Association for SQL Server (PASS) SIGhttp://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#571611Sat, 08 Apr 2006 21:13:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:571611argosIs there any system stored procedure to display text of an index? <br>(like sp_helptext)http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#821215Fri, 13 Oct 2006 04:28:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:821215Louis Davidson<p>Now, I will admit up front that I haven't technically tried out all of their bits and pieces of the following...</p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#1224160Wed, 06 Dec 2006 19:01:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:1224160 SQL Server 2005 optimization « Weblog <p>PingBack from <a rel="nofollow" target="_new" href="http://blog.allahbaksh.com/?p=36">http://blog.allahbaksh.com/?p=36</a></p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#2043187Sat, 07 Apr 2007 04:40:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:2043187Louis Davidson<p>Now, I will admit up front that I haven't technically tried out all of their bits and pieces of the following</p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#2146727Sun, 15 Apr 2007 22:58:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:2146727Louis Davidson<p>Last week, I presented a query to view I/O pressure , and (to me) more usefully, look at it in a slice</p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#3160043Fri, 08 Jun 2007 14:25:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:3160043Bob Duffy's Blobby Blog<p>Introduction There are three items that any SQL Server maintenance plan should cover at a minimum: Backup,</p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#3161103Fri, 08 Jun 2007 15:38:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:3161103MSDN Blog Postings · 2007 · June · 08<p>PingBack from <a rel="nofollow" target="_new" href="http://msdnrss.thecoderblogs.com/2007/06/08/">http://msdnrss.thecoderblogs.com/2007/06/08/</a></p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#3161106Fri, 08 Jun 2007 15:39:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:3161106MSDN Blog Postings · Smart Indexing Part I - Analyzing Indexes<p>PingBack from <a rel="nofollow" target="_new" href="http://msdnrss.thecoderblogs.com/2007/06/08/smart-indexing-part-i-analyzing-indexes/">http://msdnrss.thecoderblogs.com/2007/06/08/smart-indexing-part-i-analyzing-indexes/</a></p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#4430675Fri, 17 Aug 2007 17:39:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:4430675Is this Index useful ? « Furrukhbaig’s Weblog<p>PingBack from <a rel="nofollow" target="_new" href="http://furrukhbaig.wordpress.com/2007/08/17/is-this-index-useful/">http://furrukhbaig.wordpress.com/2007/08/17/is-this-index-useful/</a></p> http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx#9025350Fri, 31 Oct 2008 00:53:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:9025350Craig Freedman's SQL Server Blog<p>SQL Server includes two DMVs - sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats - that</p>