Skip to content

Instantly share code, notes, and snippets.

@beginor

beginor/sql-server-row-count.sql

Created May 19, 2015 01:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save beginor/8a2a4a4fa6fa3b2d6cbc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save beginor/8a2a4a4fa6fa3b2d6cbc to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server Query Table Row Count
Raw
sql-server-row-count.sql
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment