[sql] Select count(*) in SQLServer

A much faster way to do select count(*) in SQLServer:

SELECT rows FROM sysindexes WHERE id = OBJECT_ID('[TableName]') AND indid <>