Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]
2023-02-20 (first published: 2020-04-14)
17,618 reads
In this article, Glen Cooper provides code that allows you to process a tree, or undirected graph of data. Lots of hierarchies fall into this category and the ability to process them is valuable in many reporting situations.
2023-01-20
2,915 reads
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
2022-07-04 (first published: 2019-10-17)
11,424 reads
This article presents a way that finds a perfect match in any bipartite graph or shows why one cannot exist.
2021-09-06
2,653 reads
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
2021-04-19
6,683 reads
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
4,859 reads
In this article, we see how SQL can be used to determine matches between two groups, given a set of preferences.
2020-01-23
6,877 reads
An interesting tutorial for linking SQL Server to a Blackberry device and viewing images.
2011-02-09
11,406 reads
Handling security in an application can be a bit cumbersome. R Glen Cooper brings us a database design technique from the real world that can help you.
2010-04-23 (first published: 2010-04-06)
6,485 reads
In a sequel to his previous article on referential integrity, Glen Cooper looks at some ways to analyze who is getting emails based on a database system.
2009-05-22
4,223 reads
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging
Comments posted to this topic are about the item MuleSoft Integration with Azure Key...
Ask SSC