SQL Server Performance Forum – Threads Archive
how to get the number of blocks in a tableHi, 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.
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.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.