Geeks With Blogs
Dennis Bottjer | MVP
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
Posted on Monday, October 30, 2006 6:59 AM SQL | Back to top


Comments on this post: Space Used By SQL Indexes

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © DennisBottjer | Powered by: GeeksWithBlogs.net