WITH ENCRYPTION can slowdown performance of SP?

Jul 2 2016 4:52 AM

Hi All,

I am using WITH ENCRYPTION in stored procedure to encrypt whole SP text. is there any performance issue generated because of that?

I am working in product based company and we have recently migrate SQL server 2014 from SQL server 2008. now we are facing some performance related issues. so i want to know whether using "with encryption" can slow down performance in SQL server 2014?

is algorithm used in SQL server 2008 and SQL server 2014 are different?

Answers (2)

Conversion of nvarchar to bigint

Advice for video storage.