Is that ever an understatement. Nevertheless, I have been finding good uses for report and group variables, in those situations where they can be used, which is in RS expressions in specific places. Of course as with any item, a few restrictions do exist in the use of variables. Link: SQL … Continue reading →
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.