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!
Category: SSC
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 […]
Code that writes code
Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries. The example I’ll give today is changing database file growth rates. If I want to change the DB file growth […]