Viewing 15 posts - 1 through 15 (of 67 total)
Thank you Alan.
As noted above, I've attached the article in PDF format (no ads) to improve the layout of the tables.
September 7, 2021 at 3:50 pm
A copy of this article is attached in PDF format, along with the resource section.
September 6, 2021 at 1:49 am
Congratulations skeleton567 on your seniority in programming! Have you worked on mainframes?
In my opinion there are two basic skills needed in programming SQL (or any other language): mechanical and engineering.
The...
August 19, 2021 at 5:26 pm
You can avoid MERGE in some cases:
https://qa.sqlservercentral.com/articles/how-to-avoid-merge-in-sql-server
January 26, 2021 at 4:57 pm
"No one will drive us from the paradise which Cantor created for us"
David Hilbert
1925
Cantor's work in set theory was a stunning development, but so was mathematical logic.
Did you know that...
January 19, 2021 at 5:00 pm
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...
April 16, 2020 at 9:44 pm
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...
April 16, 2020 at 4:03 pm
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 *...
April 15, 2020 at 7:49 pm
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...
April 15, 2020 at 6:55 pm
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,...
April 15, 2020 at 4:56 pm
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...
March 12, 2020 at 11:52 am
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...
March 12, 2020 at 3:02 am
Thank you Jeff for a more elegant computation of fnBasic.
March 10, 2020 at 4:40 pm
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.
March 10, 2020 at 1:44 pm
Viewing 15 posts - 1 through 15 (of 67 total)