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
8,550 reads
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
4,465 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,167 reads
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
2019-10-17
6,507 reads
An interesting tutorial for linking SQL Server to a Blackberry device and viewing images.
2011-02-09
11,374 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,389 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,188 reads
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
5,924 reads
By Rayis Imayev
(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Well, I’m running a bit late. Both for this month and the fact I...
Comments posted to this topic are about the item Removing TDE from a Database:...
I want to search all databases having sprocs containing text 'text I am looking...
Comments posted to this topic are about the item BDC Orchestration
Ask SSC