How big is it? Big? Really Big? Ginormous???
Yesterday, I posted a quick query Column Names by Table on how to search for a column in any table in the database. Today’s query will extend that functionality to let you know how many rows are in the table while avoiding the dreaded
SELECT COUNT(*) FROM dbo.SuperHugeTable;