Thanks for the snippet to store MERGE counts.

The script is only meant to replace MERGE where you don't have special processing on any column (such as logging a row if...

You've raised a good point about Foreign Keys.

The script assumes no constraints on the target table, other than a key.

Basically, I extracted all the records into a no-constraint table and...

It looks like a random string "exddasf" got inserted into the script when I pasted it into the article:

-- Display Source and Target tables.

SELECT * FROM [dbo].[Table1] -- Source

SELECT *...

I wrote this script because MERGE seemed overkill for something quite simple. Also, as previous comments have indicated, this script has some advantages but it can't replace the more flexible...

Performance wasn't the motivator for this script because both approaches have performed well enough for me. But if you just want to know the status of each merged record (inserted,...

By "using mathematics" I meant "proving a new mathematical theorem or quoting on old one".

I had to prove a theorem to write this script.

I'm wondering aloud how a functionally equivalent...

A SQL Server solution to this problem, without using mathematics, would be very interesting. This was a real problem that I worked on, and I expected to do some fancy...

Thank you Jeff for a more elegant computation of fnBasic.

You are absolutely right.

The main point to this article is that the definition of basic sets paved the way for an algebraic solution, which surprised me.

This sole purpose of this article was to give a rigorous proof of why the algorithm always stops with a stable mapping.

The link within this article doesn't work, so I've attached the scripts here.

“What counts is not necessarily the size of the dog in the fight- it's the size of the fight in the dog.”

Dwight D. Eisenhower

He didn't say anything about the dog's...

Nice article.

I recently wrote a Visual Basic 2005 front-end to test arbitrary connection strings (they may be shared using a simple SQL Server database).

Article (unpublished):

http://www.newdalesystems.com/newdale/Articles/Article018/TestConnection.htm

Source:

http://www.newdalesystems.com/newdale/Articles/Article018/TestConnectionSource.zip

Your script would make a nice...

This is a very clever way to table-drive a dynamic query.

Book Review

Fundamentals of SQL SERVER 2012

Sebastian Meine, Ph.D.

This book was a pleasure to read.

Sebastian offers a breezy introduction to SQL Server 2012 replication that touches on all the main...