Monthly Archives: November 2016

A Christmas Wishlist

I finally had the chance to catch up on some reading last week, and it got me thinking about sharing this list. If you are in software development, then I would consider these four books to be required reading. I’m … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Fonts and Frustration

TL;DR – There are a couple of XML files at the end of this post. If you regularly present technical material using SSMS, download these. I present technical sessions now and then – my local PASS group, SQL Saturdays, internal … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment

NULL Pain Revisited

In an earlier post, I covered an issue with special characters in Transact-SQL. I ended up creating a scalar function to handle it. Well, fast-forward a few months and now my query’s inability to go parallel is really starting to … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Compile Time Part 2

TL;DR – Square brackets do not save the optimizer any time. If you didn’t already read Part 1, you might want to go back and do that. I will easily admit that I can be rather obsessive about code formatting … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Compile Time Part 1

TL;DR – The sys.dm_exec_{query|procedure}_stats.*_worker_time fields do not include compile time. But the values in sys.dm_exec_procedure_stats.*_worker_time DO include compile time for ad hoc SQL within the procedures. Also, as a side note, a lot of indexed views can be a significant … Continue reading

Posted in Uncategorized | Tagged | Leave a comment