This Is Your Backup Schedule On Drugs

SQL Server
21 Comments
I’ve seen things Terrible things. I mean, not just working here (which, as I write this, I’m three days away from the two year mark, fingers crossed!), but also out there on the internet. Once you leave the safe confines of Brent Ozar Unlimited, you’re subject to the ravages of space. Strangers. Radiation. Strangiation. Your…
Read More

MAX Data Types Do WHAT?

SQL Server
23 Comments
Users are horrible, I know You can just never rely on them to pass in reasonable search strings. When you write stored procedures to retrieve information for them, it’s really tempting to define all your string variables as MAX length. As long as the actual data type, N/VARCHAR matches, you’re cool, right? Avoid that pesky…
Read More
Menu