Collation Explanation and Translation, part 2: one query on sys.fn_helpcollations() lists all 1011 collations in SQL Server 2005 with a description of each.
SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation
Cannot resolve collation conflict for equal to operation. In MS SQL SERVER, the collation can be set at the column level.
Searching Every Stored Procedure for a Word
Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.
SQL SERVER – 2005 Collation Explanation and Translation
How to read a SQL Server 2005 Collation name like Latin1_General_CI_AS, check which collation you have, and avoid collation conflict errors.
SQL Server Interview Questions and Answers Part 2
Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.