New Speaking Event... Confio Webinar in May

Indexing for SQL Server Performance – Smart Practices for the DBA and Developer http://ow.ly/kj9Ug 

Date: Thursday, May 9, 2013
Time: 2:00pm ET/7:00pm GMT
Duration: 1 hour

I hope to see you there!

SQL Saturday, San Juan, 4/20/2013

Come say Hi!

How many rows are in your tables?

If you need counts on all of your tables (perhaps you are doing some data mining on a new server?), you probably don't want to run a "selcet count (*)" on all the tables -- it's time consuming and resoruce intensive.

Instead, try this:

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