SQL Server Performance

TSQL to get clustered index information in SQL Server 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 10, 2008.

  1. Anonymous New Member

    Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index alone. declare @tablename sysname ; Set @tablename = '&lt;TableName&gt;' ; @tablename sysname ; Set @tablename = '&lt;TableName' ; with cte ( index_name , column_name , index_type ) as ( cte ( index_name , column_name , index_type ) as ( select i . name , c...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/03/10/3741.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3741" width="1" height="1">

Share This Page