Aug 18th, 2011
by Colin Stasiuk.
On July 27th EDMPASS was lucky enough to have Jen McCown (@MidnightDBA) as a guest (virtual) speaker. Here is the session abstract: Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is [...]
Aug 8th, 2011
by Colin Stasiuk.
Originally this blog post was going to be about how using check constraints that call functions basically eliminates SQL Server’s ability to do set-based operations and I was going to setup an example that inserted 10 rows to show that because of the check constraint that calls a function SQL Server ends up calling the [...]