Well, the DataSet .Clear() method removes all rows from all tables.  There's also a .Reset() method to reset it to its original state.  You might play around with those for...

Are you looking for any aspects in particular?  There's a good MS Utility - I think they call it Best Practices Analyzer, or something similar.  You can download it from...

Thanks, enjoy!

Great writing, as always!  Thanks

OK, just want to make sure we're talking about the same thing here.

Just wondering, but what is dbo.fsns_encrypt?

I suspect this might be an issue with parallelism, which is why I asked which service pack you are on and also asked for a...

Memory leaks can cause a problem with XP's, if they don't release memory correctly.  The XP's here properly allocate and deallocate memory.  Which service pack are you running?  If you...

This is not designed to work on SQL 2005.  SQL 2005 has built in encryption facilities that should be used instead of extended stored procedures.  On SQL 2005, extended stored...

Hi Ed,

Hmm...  I've resolved the memory fragmentation issue with the 0.9 version.  I also can't reproduce your performance issue.  I would suspect that the joins of millions of rows to...

Hi Henrik,

I sent you a message here on SSC.  If I didn't answer your questions fully, feel free to contact me directly via email. 

Thanks

Sprites on an x86?  What machine was that?   I almost blurted out C-128, but that had a Z-80 in it, didn't it?

Wow look at all the old school Vic-20 and C-64 programmers out here !  Any of you guys n gals remember the old Compute! and Compute!'s Gazette mags?  I spent...

The one program I wrote that *really* sticks out in my mind over the years was one I wrote for a Z-80 Assembler Language class way back in the day...  It...

LOL.  Thanks Phill.  I usually try to work with critics to explain my position in a rational way and listen to their position in a patient way.  Usually there's middle...

Further reading resources

(forgot these in the article - sorry!):

Daitch-Mokotoff Soundex:  http://www.avotaynu.com/soundex.html

Double Metaphone:  http://www.ddj.com/184401251?pgno=2

Celko Improved Soundex:  http://books.elsevier.com/bookscat/links/details.asp?isbn=1558605762

NYSIIS:  http://www.dropby.com/NYSIIS.html

Jaro-Winkler:  http://www.dcs.shef.ac.uk/~sam/stringmetrics.html#jarowinkler

Levenshtein Edit Distance:  http://www.dcs.shef.ac.uk/~sam/stringmetrics.html#Levenshtein

Also a minor...