Ran into an interesting error message today. On one of our lab servers, I was making some changes to test a deployment and I was running FULL database backup and adding/removing some data files on the same database.

(Dave Green) I was recently adding a check constraint to a table in SQL Server, and noted some behaviour which surprised me, so I thought I’d share it with you. I’ve tried this on SQL Server 2012 and 2008 R2.

In SQL server, people sometimes use iff function, which is also an Excel function, to assign different values based on a condition. For example, the following query returns 1 if the amt is less than 50, and 0 otherwise.

(Michael Otey) Q: I’m getting an error changing the schema for a table using the Table Designer in SQL Server Management Studio (SSMS). I’m trying to change a column from nulls allowed to not null. The table has about 200,000 rows.