have a look at:

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yoursqlserver\instance /d yourdb /I /F c:\yourscriptfolder

You can do this with SSMS .

If you browse to the tables overview in the object browser and then select the object browser detail pane, you can sort on e.g....

Jack Corbett (12/3/2010)

---

jason.spangler (12/3/2010)

---

I stand corrected everyone. Sorry about the incorrect information. I was told in a class that it had to be cleaned up, and never really...

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...