Our powers combined, I am Captain Query Plan! On February 22, 2011February 21, 2011 By John Morehouse A brief look at query plans and how setting environment options will change the query plan.
I sold my soul. I bought a Mac. On February 14, 2011February 13, 2011 By John Morehouse I sold my soul and purchased a Mac. As a SQL Server professional, sometimes this is considered forbidden fruit.
Symmetric Key Experiment. Truth or fiction? You decide. On February 11, 2011February 11, 2011 By John Morehouse A look at determining if you can use a view to decrypt data on the fly, either directly from within the view or using a function in a view.
Throw more wood on the fire! On February 1, 2011January 30, 2011 By John Morehouse A brief thought as to why adding more rows to a table gave me my expected results in the execution plan. Namely, a key lookup.