Thursday, September 9, 2004


SQL Server Performance newsletter

I subscribed to the SQL Server Performance newsletter earlier this year and I usually learn something for each issue.

Did you for example know that:

  • Calling a stored procedure sp_something is slower than usp_something?

  • A very fast (but not 110% accurate way) of doing SELECT COUNT(*) from <table_name> is

                 SELECT rows
                 FROM sysindexes
                 WHERE id = OBJECT_ID('<table_name>') AND indid < 2


No comments:

Post a Comment