Category: Uncategorized

I take occasional “brain breaks” at the office, to refresh me before I set upon the next course of work.  Mostly I like to troll around a favorite set of websites and links from them. So it was today that I happened across this book recommendation – I think on Brent Ozar’s site – for a […]

I just recorded a couple of Midnight Snacks on NULLs, and I felt inspired to blog about it too. Equals Null Mistake (video) First, let’s talk about a mistake that’s easy to make, especially if you’re in the throes of a coding frenzy, tossing JOINs here and WHERE clauses there, to get your data set returned […]

While I was filming the video to Thinking…Query, named Insert Non-Duplicate Rows, I got the question: instead of a correlated subquery, couldn’t you just use a join with a negative condition?  So I included that discussion in the video.  To review: the problem we’re trying to resolve is inserting rows FROM Table1 INTO Table2, ignoring duplicates.  […]