March 2007 - Posts

• Can you trust your constraints?

  SQL Server allows you to temporarily disable your CHECK and FOREIGN KEY constraints. I would not recommend this as part of your regular production schedule, but there are certainly cases where this comes in handy. One example is if you’re copying thousands Read More... Posted Thursday, March 29, 2007 5:21 PM by Hugo Kornelis | 14 Comments Filed under: Best Practices, Constraints

• Back with a vengeance!

  It’s been quite a while since my last blog post. Almost three months, in fact. In case you have been wondering if I was ill, dead, or abducted by aliens – not at all. The reality was far worse: Adam Machanic has coerced me into contributing a chapter Read More... Posted Thursday, March 29, 2007 5:11 PM by Hugo Kornelis | 2 Comments Filed under: Personal