I often copy paste the output of "sp_helptext" for some of our stored procedures. For whatever reason, they often paste with numerous blank lines between each meaningful section of code. Here is how I get rid of those lines:
Author: justino
Just how big ARE those tables?
If you need to know the size of all your tables, here's a simple query to get you where you need to go: