Here's a quick and easy script you can use in SQL Server 2005 to return the number of rows in a table, along with the index size on the table, the reserved space, and the data space for the table. If you're familiar with the system stored procedure sp_spaceused, this information may seem familiar to you. I took some of this code from that procedure, but am presenting it in such a way so that it works for all tables in the database at the same time. This makes it much easier to query, and...