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.
Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – SQLServerCentral.