Some general scripts for SQL Server to get a data about tables in your databases

sql-server_row-count-and-size.sql

USE DatabaseName
GO

CREATE TABLE #temp_table (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))

SET NOCOUNT ON
INSERT #temp_table
EXEC sp_msforeachtable 'sp_spaceused ''?'''

SELECT a.table_name,
       a.row_count,
       COUNT(*) AS col_count,
       a.data_size
FROM #temp_table a
INNER JOIN information_schema.columns b
      ON   a.table_name collate database_default = b.table_name collate database_default
GROUP BY a.table_name,
         a.row_count,
         a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp_table

sql-server_row-count.sql

SELECT  '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS fulltable_name,
        SCHEMA_NAME(t.schema_id) AS schema_name,
        t.name AS table_name,
        i.rows
FROM sys.tables t
INNER JOIN  sys.sysindexes i
        ON  t.object_id = i.id
       AND  i.indid < 2