Shane O’Neill discusses how constraints can in some cases improve database performance:
David Morrison ( blog | twitter ) followed up with his presentation on “Query Plan Deep Dives” (I had seen this at SQL Bits, but it’s a great session so I had no problems watching it again) and, as an aside, through his presentation he showed us the compound effects that can happen from not specifying a columns
NULLABILITY(it’s got letters so it’s word-like…)Now his slides and scripts are up on his blog and they do a great job of walking you through them so check them out and you’ll see the compound effects they create!
Shane’s overview of two presentations was interesting, but despite all his rage, he is still just a Nicholas Cage.