Compare data of two tables
Script to facilitate the comparison of data between two SQL Server tables
2019-09-23 (first published: 2019-09-07)
4,119 reads
Suresh Kumar
Generate Large Amount of Data For Performance Testing
Generate large sample data for your performance and other uses
2018-04-24 (first published: 2018-04-18)
3,099 reads
Cache Snapshots And History Snapshots in SSRS 2016
The various Snapshot options in Reporting Services 2016 explained.
2018-04-03
3,646 reads
Transaction Replication: Multiple Publishers, Single Subscriber
How to configure multiple publishers and single subscriber replication?
2018-02-26
6,074 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers