james.wheeler10 (4/14/2010)

---

magarity kerns (4/14/2010)

---

rmd0 (4/14/2010)

---

One issue I have with this solution is that MD5 *will* have collisions with moderately "wide" tables, especially when bit columns are involved. In fact, I...

Nadrek (4/14/2010)

---

A few comments with the underlying assumption that the desired result is a (potentially) more efficient method that is guaranteed to return the same results as the "long way"....

magarity kerns (4/14/2010)

---

Mike C (4/13/2010)

---

Nice article! I implemented something very similar for loading data warehouses and datamarts a while back. One thing to keep in mind is that...

magarity kerns (4/14/2010)

---

hennie7863 (4/14/2010)

---

I have not read the article in detail, so correct me if i'm wrong, but the hashbytes accepts only one column (of one type character) and in...

tarquin (4/14/2010)

---

Wrapping hashbytes with checksum is not bad as long as you include all columns in your join as indicated and create the index including all columns required for the...

I wouldn't expect many collisions with MD5 unless you're processing 2^64 or more rows. If you're getting collisions with MD5 or SHA I would immediately suspect the concatenation function...

Wrapping HASHBYTES with CHECKSUM is not a good idea. CHECKSUM generates a 32 bit hash using a simple bit-shift+XOR algorithm. So it provides very poor uniqueness with the...

When I used HASHBYTES my solution was to covert all columns to varbinary and concatenate them together into one value to pass to hashbytes. It's pretty easy to auto-generate...

Nice article! I implemented something very similar for loading data warehouses and datamarts a while back. One thing to keep in mind is that you can actually use...

You can write a t-sql udf that chops your data into ~7800 byte chunks (symmetric encryption adds some bytes of overhead). Then concatenate the encrypted string back together. ...

On sql 2005 and later you should go with the built-in encryption functionality. Extended procs are deprecated since 2005 in favor of clr. The built-in functionality is also...

From Penn Station catch the train up to 50th street and 8th avenue. Then walk East two blocks to 6th Ave ("Avenue of the Americas") and one block...

desmati (3/26/2010)

---

I have a very fast function in both c# and tsql that returns if a word is stop word or not.

I tried to change the EBNF and the ConvertQuery...

On SQL 2005 they have the concept of "noise word lists". These are essentially the same thing, but they're...

Hi Desmati,

If you create a custom stopword list on SQL...