Know Your Database Statistics?

Its very important to know your database stats while planning for some architectural update or database migration. The beforehand information would always add a plus to mitigate any risk and proactively take actions.

Below is SQL Server script that provides information about database stats which include list of all tables, there respective record count, allocated size and so on.

The above script uses in build stored procedure of SQL Server database engine “sp_spaceused” to accomplish the task.