Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by susre
-
How can I retrieve the size used for each index in a table?
You are right, it should be certanly this value: (i.used - i.dpages) Do you know how can I correct the query?- susre
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How can I retrieve the size used for each index in a table?
This query can be more useful, the only problem is that i got a -8 result Index_Size_In_KB so for sure there is something wrong, what do you think? DECLARE @pagesize int select @pagesize = v.low / 1024 from master..spt_values v where v.number=1 and v.type=N'E' SELECT o.name TableName, i.name...- susre
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How can I retrieve the size used for each index in a table?
I need to retrieve the size used of each index used in a table. How can i do? sp_spaceused is not useful, because i need not the sum, but the size of each index. Thank you very much,- susre
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
