David Bird

Compare the Data in Two Tables

These queries are used to compare the data in two tables.   In these examples all the rows in each table is retrieved and compared using the UNION ALL command.  I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]

2007-08-09 (first published: )

2,752 reads


Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR


Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes


This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share


A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs


Primary Key and Clustered Index

By RonMexico

A topic I always get confused with is primary key vs. clustered index. I...

odd error message in function in a proc

By tcronin 95651

I have a cursor which has calls a function (sorry for  design this is...

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers