NULL Archives

What’s Worse Than a NULL? An Incorrect NULL

June 2, 2014 by Thomas LaRock

Recently it was brought to my attention that the query_hash and query_plan_hash columns inside of sys.dm_exec_requests were returning NULL values. I think everyone knows how I feel about NULLs already, but this was slightly more concerning. See, I work for a company that makes this wonderful tool called Database Performance Analyzer (DPA), and we rely … Read more

SQL Server and NULL Values

November 1, 2013March 3, 2009 by Thomas LaRock

I seemed to have struck a minor chord with my hatred for database triggers. I had very few comments, but a handful of emails and exchanged even more tweets on the subject. But one thing was made clear to me and that is people wanted to hear about why I disdain NULL values. Fortunately for me … Read more