Geeks With Blogs
Good BI SQL Server Johnno Maloney

Just a little piece of code I wrote to see the sizes and space used of all the user tables in one query. It is simple enough; I basically rewrote the “sp_spaceused” system stored procedure because it would only return the space used for one table at a time and it is much more convenient to see the size and record count of all the tables in a database.

I add it as a template in the template explorer:

 Table Sizes.sql

 

 

 

 

Posted on Monday, January 18, 2010 4:24 PM | Back to top


Comments on this post: Table Sizes

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


Copyright © GoodBISQLServer | Powered by: GeeksWithBlogs.net