The Performance of Traversing a SQL Hierarchy.
Improve SSIS data flow buffer performance.
Myths and Misconceptions about Transaction Isolation Levels – SQLServerCentral.
SQL Server XML Questions You Were Too Shy To Ask.
The LookupCTE trick described here is pretty slick. These days I find myself working with large databases where these things really matter and I found this post quite interesting. Improving Query Performance by using correct Search Arguments – SQLServerCentral.
Why every SQL Server installation should be a cluster – SQLServerCentral.
Clever. I don’t think I had ever heard of EXCEPT. Using EXCEPT to Determine Row Differences – SQLServerCentral.
This is a good list of basic security measures you can include when you install SQL Server, very similar to my own. SQL Server Security Checklist.
Really basic, but possibly difficult to remember in detail if you don’t work with the nuances all the time. An excellent review, and some helpful comments on the use of snapshot isolation… Transaction Isolation Levels – SQLServerCentral.
Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – SQLServerCentral.