SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2011

How to find out which Table is not having rows in SQL Server?


Many times while tuning our production databases we might try to find out the list of tables not having even a single row of data. Today, I am going to show a simple script which could be used to get a list of tables having ZERO rows.



Read more

5 comments, 2,200 reads

Posted in Juggling With SQL on 1 October 2011