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.
No kidding: “One thing I have learned about Microsoft SQL Server is that regardless of your years of experience with the product or any given part of it clustering, SSIS, etc., there is always something left to learn – even things that in retrospect seem obvious well, duh! were new … Continue reading →
Clever. I don’t think I had ever heard of EXCEPT. Using EXCEPT to Determine Row Differences – 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.
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.
Indexed Views – SQLServerCentral. This post describes an interesting feature that I have never been able to use. Unfortunately, indexed views come with a fairly long list of restrictions and I always seem to run afoul of at least one of them.