The ANDs, ORs, and NOTs in a T-SQL query’s WHERE clause can get confusing, especially if you’re thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!
Author: Jen McCown
When was my last backup / CheckDB / index maintenance?
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean SQL Server instances. So how do we go about this? Well, there’s the easiest way – you knew I’d be mentioning Minion Enterprise, right? – and then there’s the hard way. The easiest way If you have Minion […]
Goodbye, SQL Soldier
We lost Robert L Davis this week, unexpectedly. I’m far too short on words today, so I’m going to borrow from Kendra Little: Robert was that rare funny person who made jokes without malice. He had a super quick wit, and he could make a sharp joke about politics, but he was a very kind […]