How To Find A Perfect Match
This article presents a way that finds a perfect match in any bipartite graph or shows why one cannot exist.
2021-09-06
2,495 reads
R Glen Cooper
- Interests: SQL Server, .NET, Mathematics
Navigating Trees With CTE
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
5,562 reads
How To Avoid MERGE in SQL Server
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. […]
2020-04-14
10,244 reads
Gap Analysis Using Algebra
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
4,747 reads
Stable Marriages Using SQL Server
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,581 reads
Using Graph Theory To Group Records
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
2019-10-17
7,131 reads
Calling SQL Server With A BlackBerry Phone
An interesting tutorial for linking SQL Server to a Blackberry device and viewing images.
2011-02-09
11,399 reads
Row Oriented Security Using Triggers
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,458 reads
Mathematical Auditing Of Email Broadcasts
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,214 reads
Ordering Tables To Preserve Referential Integrity
When moving data in related tables between databases, the order sometimes matters. New author Glen Cooper brings us an article that discusses the issues in maintaining referential integrity.
2009-03-20
6,050 reads
Blogs
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Saturday Jacksonville Slide Decks
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
Forums
EXECUTE SSIS Pacakge from command line with environment variables
hi, I am trying to execute ssis package from command line. I also tried...
SQL Server replication migration from sql 2012 to 2019
Hello I need to migrate existing sql server 2012 replication to the SQL Server...
Failed code dcexec -u -s 3 -i "$(ESCAPE_DQUOTE(MACH))\$(ESCAPE_DQUOTE(INST))"
Hello, I cant understand what this code is doing, can some one please...
Ask SSC