TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask.
The Performance of Traversing a SQL Hierarchy.
Improve SSIS data flow buffer performance.
Myths and Misconceptions about Transaction Isolation Levels – SQLServerCentral.
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.
Here we go with developers again. I wonder if the ones that go around creating this particular kind of mess are also the ones that tend to flunk the index/performance quiz? Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization.
Well at least I “passed” (4 out of 5). Hint: read the questions CAREFULLY. Most SQL users flunk performance test | ITworld.
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.