Hi All

What's the most efficient way to see if a table contains more than 30 rows?

Obviously "select count(*) > 30" will work but will this count every row before doing the comparison? I suspect it does and was wondering if there was a better way. I'm using SQL Server 2008.

Thanks

Russell