Monthly Archives: February 2011

Our powers combined, I am Captain Query Plan!

A brief look at query plans and how setting environment options will change the query plan. Continue reading

Posted in Performance Tuning | Tagged , | 2 Comments

I sold my soul. I bought a Mac.

I sold my soul and purchased a Mac. As a SQL Server professional, sometimes this is considered forbidden fruit. Continue reading

Posted in General Conversations | Tagged , | 2 Comments

Symmetric Key Experiment. Truth or fiction? You decide.

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. Continue reading

Posted in Encryption | Tagged , , | 1 Comment

Throw more wood on the fire!

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. Continue reading

Posted in Indexes | Tagged , | 1 Comment