A collation conflict means character expressions use incompatible comparison rules. I choose the intended rules before applying COLLATE.
SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table
Paging in SQL Server 2005 with ROW_NUMBER: CTE vs. derived table. I compare both methods and show they give the same performance for common queries.
SQL SERVER – 2005 Explanation and Example – SELF JOIN
A self join joins a table to itself with table aliases. When to use one, why the joined columns must share a data type, and an employee example.
Composite Keys: Match Complete Pairs Instead of Separate Lists
Composite keys need a complete pair match when the allowed values are defined together. I don’t split the components into independent lists. Doing so can admit combinations that were never allowed.
SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator
What the Left Semi Join showplan operator means, along with Left Anti Semi Join, Right Anti Semi Join and other joins you see in a text execution plan.
How the Main System Views Connect
Learn how the main system views connect through object_id, schema_id, index_id, and column_id so catalog joins stay accurate.
SQL SERVER – Explanation SQL SERVER Merge Join
What a Merge Join needs and when it is fast: two sorted inputs with matching column types. Presorted B-tree indexes make it quick, extra sorts make it costly.