amimaro · March 16, 2018 12:54
diff --git a/countRowsTables.sql b/countRowsTables.sql
 -- Query count rows from tables

 SELECT T.name AS tableName, 
       I.rows AS rowCount 
 FROM   sys.tables AS T 
       INNER JOIN sys.sysindexes AS I 
               ON T.object_id = I.id 
                  AND I.indid < 2 
 ORDER BY I.rows DESC
diff --git a/MSSQL Queries b/MSSQL Queries
 Some MSSQL Queries
	-- Query count rows from tables

	SELECT T.name AS tableName,
	I.rows AS rowCount
	FROM sys.tables AS T
	INNER JOIN sys.sysindexes AS I
	ON T.object_id = I.id
	AND I.indid < 2
	ORDER BY I.rows DESC