I hope that you are able to find a solution soon, Safenet does seem to be more Oracle pro. As I mentioned the SQL Server applications we supported were not...

It is hard to say how long it will take as there are quite a few dependencies (hardware, network traffic etc...) and the best would be to try it out...

@Indianrock - we used Safenet at my old workplace and as you may have noticed it is cumbersome to manage the encrypted data. In fact we even used it on...

@LutzM & @ninja: Thanks for the suggestion, I have noticed a couple of stored procedures have benefited by using CTEs and removing UDF calls. I am trying to rewrite some...

@ninja's_RGR'us : Thanks for your feedback, will try my best to follow your advice.

Hello All: Please avoid trivial arguments on this forum and kindly take a look at the attached execution plans and DDL scripts. I would like to accept the fact that...

@Syed: Yes we do perform regular maintenace jobs.

@Gila & Grant: I will try to add the definitions and execution plans as soon as I get a chance

@Nils: Yes the queries...