Encrypted Stored Proc Performance

Does anyone know if there executing encrypted stored procedures in SQL
Server 2005 is any slower than regular ones?
Thanks,
KripHi, Krip,
There really should be no difference in performance, since the execution of
the stored procedure is not from the text. Maybe recompiles take slightly
longer, but I would not know.
The gentleman in this thread from 2004 felt that his encrypted stored
procedures ran faster, but the full testing method was questioned.
http://groups.google.com/group/micr...80e7a94e230ea8f
From the same time period Jacco Schalkwijk (SQL Server MVP) noted that the
difference was negligable.
RLF
"Krip" <amk@.kynetix.com> wrote in message
news:DC3CA6E3-A4D6-4B1C-99AB-88660359C9B7@.microsoft.com...
> Does anyone know if there executing encrypted stored procedures in SQL
> Server 2005 is any slower than regular ones?
> Thanks,
> Krip
>|||Thanks Russell. Makes sense. Good to hear from you!
-Krip

emptying database

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script."Phung" <purwa@.purwadhika.comwrote in message
news:1193056060.280220.235250@.e9g2000prf.googlegro ups.com...

Quote:

Originally Posted by

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.
>

You could drop and recreate the DB.

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||If you are dropping and recreating , don't forget to take a script backup of
the db

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"Phung" <purwa@.purwadhika.comwrote in message
news:1193056060.280220.235250@.e9g2000prf.googlegro ups.com...

Quote:

Originally Posted by

Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.
>