SQLServerCentral.com Scripts tagged heapindexhttp://www.sqlservercentral.com/Scripts tagged heapindex posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Script for no of Index in a table This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.

]]>http://www.sqlservercentral.com/scripts/Indexing/94334/Fri, 23 Nov 2012 07:00:00 UThttp://www.sqlservercentral.com/scripts/Indexing/94334/