I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.
SQL SERVER – 2005 – Performance Dashboard Reports
SQL Server 2005 Performance Dashboard Reports show CPU, IO, blocking and missing index problems as they happen. How to set them up and read them well.
SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON
Error 8101 means you gave a value for an identity column. What IDENTITY_INSERT does, why there are two different errors, and why TRY CATCH misses it.
SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query
For Error 701, insufficient system memory, compare max server memory with min server memory, check the paging file size, and free caches with DBCC commands.
SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Msg 128, The name is not permitted in this context, shows up when one column is used as the DEFAULT of another. Use only constants, expressions or variables.
SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.
SQL SERVER – Union vs. Union All – Which is better for performance?
UNION removes duplicate rows like SELECT DISTINCT, while UNION ALL keeps them all. My early notes on Union vs. Union All, with a link to the rewritten post.