SQL DB Size with SP, Elmaha and Row

Table wise row count:

SELECT sc .name +'.'+ ta. name TableName

,SUM( pa.rows ) RowCnt

FROM sys .tables ta

INNER JOIN sys. partitions pa

ON pa .OBJECT_ID = ta .OBJECT_ID

INNER JOIN sys. schemas sc

ON ta .schema_id = sc .schema_id

WHERE ta .is_ms_shipped = 0 AND pa. index_id IN (1 ,0)

GROUP BY sc. name,ta .name

ORDER BY SUM( pa.rows ) DESC

Table wise size details:

SELECT object_name (id) [Table Name]

       ,[Table Size] = convert (VARCHAR, dpages * 8 / 1024) + 'MB'

       ,create_date

       ,modify_date

FROM sysindexes i

       ,sys. tables t

WHERE

       i.indid IN (0, 1) AND

       t.object_id = i.id

ORDER BY i. dpages DESC

Object count details:

SELECT

  type,

  total_count  = COUNT (*),

  last_crdate  = MAX (crdate),

  last_refdate = MAX (refdate)

FROM (

  SELECT

    type = CASE

      WHEN xtype = 'U' THEN 'table'

      WHEN xtype = 'V' THEN 'view'

      WHEN xtype = 'P' THEN 'procedure'

      WHEN xtype IN ('FN', 'TF', 'IF') THEN 'function'

    END,

    crdate,

    refdate

  FROM sysobjects

  WHERE xtype IN ('FN' , 'TF' , 'IF' , 'P' , 'U' , 'V' )

) s

GROUP BY type