Category: sqlserverpedia-syndication

Compare tables to find missing rows

Post author By Jen McCown
Post date November 14, 2013
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on Compare tables to find missing rows

Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a list of orders to an imported set of data in a staging table. Or, we’re identifying customers in the database that aren’t on the call list. Whatever the application, finding out the difference between one […]

Tip: OVER and PARTITION BY

Post author By Jen McCown
Post date November 14, 2013
Categories In sqlserverpedia-syndication, SSC, Tech and Learning

I like to repost this blog about once a year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate information without using a GROUP […]

Quick note: Redgate SQL Data Compare using the command line

Post author By Jen McCown
Post date October 22, 2013
Categories In sqlserverpedia-syndication, SSC, Tech and Learning, Tips

I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups and errors with the SQL Data Compare command line interface, but one particular StackOverflow post solved my final problem. So here’s the final solution: Create a data compare project using the Redgate GUI. Run the compare […]