SQL Server Performance newsletter
I subscribed to the SQL Server Performance newsletterearlier 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
WHERE id = OBJECT_ID('<table_name>') AND indid < 2