SQL Server Indexes: Tibor Karaszi's sp_indexinfo
Wednesday, February 18, 2009 at 12:11PM His description, in part:
I can't count how many times I wanted to know "more" about physical attributes for a table, including index information. So I end up running sp_helpindex, some SELECT over sys.indexes, some reports in SSMS, some other queries against other catalog and dynamic management views, etc. I wrote this procedure for those cases. Here's my version of a procedure to give me information like: For this, I use a number of sources, like sys.indexes, sys.columns, sys.partitions, sys.allocation_units, sys.data_spaces, sys.dm_db_index_usage_stats etc.
Go get the script here. And while you're on his site, check out his terrific explanation of the datetime data type.


Reader Comments (1)