Thursday, June 08, 2006

[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 <>

No comments:

Post a Comment