how to get the number of blocks in a table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to get the number of blocks in a table

Hi, I was wondering if I can extract the information pertaining to number of blocks (used blocks) in a user table. Is this information stored in any of the system tables. I am able to get this information in Oracle, but could not find it in sql server.
thanks!
Search Books Online for discussions of database architecture. No idea if it’s just the different lingo, or perhaps the (perceived) overcomplicated nature of Oracle.
If you are looking number of blocks on the disk, I don’t think there is any way to get it in sql server. What is your requirement? MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>