dant12 (12/2/2010)

---

ALZDBA (12/2/2010)

---

Since OP stated order is of importance, maybe a join on col1 helps to restrict the cartesian product as well as the where-clause for nMatches >...

gaestes (12/2/2010)

---

@ALZDBA - I found an issue with using the Checksum for the equal compare. I have 2 differing rows that produce the same checksum. They have the...

I haven't noticed it would not cleanup the trace def in systraces after the end time.

Tested in SQL2000 / SQL2005 / SQL2008R2 CU4 .... ehm .... yes SQL2008 r1 is...

Since OP stated order is of importance, maybe a join on col1 helps to restrict the cartesian product as well as the where-clause for nMatches > 5

/* 100%...

PAH-440118 (12/2/2010)

---

Thanks for this article. it was just what I needed and a feature I did not know about. I have been experimenting and it looks great however I get...

You also need to take into account, tempdb will need to be large enough to hold all the working sets data.

/* 100% equal */

Select L.IdNo

...

Can you post some execution results and timings ? (cpu , elaps, io rates)

Seems to me pulling this kind of stuff into your CLR space could easily blow up your...

The checksum values themselves are not comparable, with regards to order, >, < !

It's just a hash value, so can only be used in an equation.

But it will be noticeable...

You're getting the arithmatic overflow, because checksum generates:

declare @a int, @b-2 int, @c int

select @a=checksum(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)

, @b-2=checksum(10,2,3,4,5,6,7,8,9,1,11,12,13,14,15,16)

,@c=checksum(14,2,3,4,5,6,7,8,9,10,11,12,13,1,15,16)

-- Which one is closer to @a? @b-2 or @c?

-- I'm getting...

did you experiment with CheckSum peristed ( and indexed ) computed columns to detect perfect matches quickly ?

, RwCheckSum as checksum(col1, col2, col3, col4, col5, col6,...

GilaMonster (11/29/2010)

---

Grant Fritchey (11/29/2010)

---

Exactly! I regularly have...

GilaMonster (11/19/2010)

---

<evil grin> I'll save...

GilaMonster (11/18/2010)

---

CirquedeSQLeil (11/17/2010)

---

I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to be deployed. ...

Jack Corbett (11/17/2010)

---

For any chapter leaders that may not be on Twitter but are here, I started a thread on the chapter leaders forum about handling money, http://tinyurl.com/3ywxkbq. I'm...

- Are there any database references in your script ?

If so, did you modify those to point to your intended database ?

- what kind of script objects does...