amimaro/MSSQL Queries

## 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

## 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