Varying Results with Subquery, ORDER BY, MAXDOP

In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking up (as long as you attribute properly).  Speaking of which… Saturday in the SQL Saturday #63 Dallas speaker room, Erin Welker (blog) asked about a problem with a query that’s getting varying results depending on the MAXDOP […]

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 […]

Session: Unraveling Tangled Code

Here is the landing page for my session, “Unraveling Tangled Code”. Here you’ll find downloads and links to recordings, as I can get around to placing them. Feel free to ask me questions via email, Jen at MidnightDBA.com (or on Twitter)! Abstract: Once upon a time, you inherited an application or a database that was […]