I copied the code from the article verbatim

ran fine in my SQL 2005 boxes (build 3042 and 2047)

I am guessing it won't run in SQL 2000

Dan: your code has a...

I don't like dedupe, let me tell you that 🙂

But I can't imagine how this WHILE loop would work on millions of rows of data comparison

I had issues with comparing...

What a great start to my day, answered the right answer (#2) and told it was wrong

I agree, what's with recent QotD mishaps?

You had no idea how important 1...

Does that mean this 2 lines below, converts @C to nvarchar(8000)?

meaning ANY casting to nvarchar always give it maximum length of 8000?

declare @C varchar(800)

set

me a little bit confused too, what's the difference between this Question, and the one 2 days ago?

TODAY

CASTing

Second question of day: what is the len of @C?

declare

Personally, thus far, I find SQL 2005's GUI for Log Shipping pretty good and easy to use

for your script, the TARGET server/DB are always in NO RECOVERY? so it's more...

Useful discussion

It is a bit harder when the SQL Servers are hosted off-site to collect "stuff"

and that I am not yet on the "critical error" production email list 🙁

as mentioned couple posts above

Table Variable is not transaction-controlled is something to watch out for too

you cannot rollback on it

I only learned about that recently after reading the T-SQL Querying...

This has been helpful, after I spent 0.5 day yesterday trying to figure out XQuery in T-SQL as DBA

in the end, I cast XML to VARCHAR and PATINDEX it.... 🙁

Can...

Not that I care, but it is one confusing question & answer

I have actually done this, and this is my SQL script for all-system-DB's-except-master and they did work, no trace...

Pretty cool neat VBS

I am playing with them already

I suppose SSIS/Batch can work equally well for the same thing

I don't know why SSMS 2005 took out...

Weird, your CTE code took 16 seconds (twice) on my SQL Server

that is not VERY VERY fast. Anyway, we don't have the need for it, I was just curious

16 seconds...

Sounds somewhat like SCRUM

The Scrum Development Process

Scrum is an agile process for developing software. With Scrum, projects progress via a series of month-long iterations called sprints.

Scrum is ideally suited for...

Interesting

More interesting if you did a batch insert test and IF EXISTS vs. UPSERT

1 statement isn't enough to prove the point

If UPSERT can reduce 50% read and 50% overall time,...