Geeks With Blogs
Good BI SQL Server Johnno Maloney January 2010 Entries
Table Sizes
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

Copyright © GoodBISQLServer | Powered by: GeeksWithBlogs.net