Determining Table sizes in MS-SQL
Hi, I was searching for a query that will give me the size of the table in MS-SQL, here it is.
exec sp_spaceused <tablename>
…gives you…
name rows reserved data index_size unused
<name> 17991232 12636448 KB 11051664 KB 1583816 KB 968 KB
<name> 17991232 12636448 KB 11051664 KB 1583816 KB 968 KB
–
—————————————————
*Free* software is a matter of liberty not price. You should think of “free” as in “free speech”.