191.aspx

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