Monday, October 30, 2006 2:59 AM dbottjer

Space Used By SQL Indexes 

1
2
3
4
5
6
7
8
9
10
11
 
select 
    [name] As IndexName,
    type_desc,
    space_used_in_kb = (page_count * 8.0),
    space_used_in_mb = (page_count * 8.0 / 1024.0) 
from 
    sys.indexes I
inner join
    sys.dm_db_index_physical_stats(db_id(), object_id('.'), null, null, null) P on I.[object_id] = P.[object_id] and I.[index_id] = P.[index_id]
Order By
  space_used_in_kb desc
Filed under:

Comments

# Space Used By SQL Indexes

Wednesday, November 01, 2006 5:31 PM by DotNetKicks.com

You've been kicked (a good thing) - Trackback from DotNetKicks.com