Hi,

I haven't done any actual performance comparisons - but I would venture a guess that the main benefit you'd get from performing the encryption on the server would be that...

The functionality (and, in this particular case, syntax) are part of the ANSI SQL99 standard.

Thank you prashanth.  I appreciate your feedback, and hope you find some of my other work helpful as well.

Hi Elizabeth,

Per our emails, this issue (memory fragmentation) has been resolved.  The newer version (v. 0.9) is available for general download on SQL Server Central.  Thanks for bringing this to...

There was a "memory fragmentation" issue with the prior version.  The memory was being released properly in C++, but SQL Server was not reclaiming it in a timely manner.  I've...

There was an issue with memory fragmentation for very large data sets (3 million+ rows in testing.) Make sure you have the most recent copy installed (v. 0.9), which...

Or, if you wanted to do it the .NET way (as opposed to VB6 style), Fill a DataSet and access the two tables individually. That, or open a SqlDataReader and...

You hit the nail on the head: "And running a cursor ... specifically when there is no logical way to perform a set operation, is a valid application of an available tool."

Very,...

Exactly right.  Trusting a TABLE variable (as opposed to a Temp. Table, or any other table for that matter) not to use TEMPDB is a fallacy.  There is no specification...

SQL is set-based.  Everything is done in sets.  Almost anything (with very, very, very few exceptions) that you can do with CURSORS can be done with set-based SQL commands +...

Surprisingly enough, when doing mass UPDATES or DELETES on very large tables, I've found that using a WHILE loop to limit the number of rows affected at one time gives a...

Hi Ed,

The supplied XP's do perform AES 256 bit encryption/decryption.  The code used is based directly on the algorithm published by the authors of AES/Rijndael (Joan Daemen and Vincent Rijmen).  If you're...

According to Visual Studio Magazine, http://www.ftponline.com/vsm/2005_08/magazine/features/rjennings/, SQL Express supports the same native encryption tools available in SQL 2K5.  I can't confirm that myself since I removed Express from my system and...

There are still plenty of software houses that don't care about quality, scalability, etc.  I worked for one in the not-distant past.  You can attempt to take leadership positions and...

With SQL 2K5, native data encryption and key management are built right into T-SQL.  In addition, you can access the CryptoAPI from within .NET Stored Proc code if you want to...