How much overhead does encryption add to a SQL Server query This is an off-site link.  Please review our Terms of Service for additional information.

(Dallas Snider) From visual inspection alone, one can deduce that decrypting an encrypted column using the DecryptByKey function in a SELECT statement will take longer than selecting the column stored in plain text. If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. I have heard this expression also, which leads me to ask the question "How can we quantify this additional overhead?"

Read this article...

comments powered by Disqus