Compare Parallel Data Streams

This a script to compare two parallel data streams, in my case production and QA.  Two extracts were created and a mapping table was created as a look-up between old and new recordids.  A final table TestResults was created to hold the results of the comparison.  The comparison table names and join syntax are controlled […]

2003-08-21

134 reads

Blogs

Captioning Options for Your Online Conference

By

Many conferences have moved online this year due to the pandemic, and many attendees...

Daily Coping 24 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Virtual Log Files

By

Today’s post is a guest article from a friend of Dallas DBAs, writer, and...

Read the latest Blogs

Forums

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Sql Server Specs Question

By smattiko83

Hi, I have two different servers that I do a bulk insert on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers