Tag Archives: sql

T-SQL Tuesday, Microsoft Connect Edition

This is a bit of a deviation from my usual post. You can thank Brent Ozar for that. He decided to host Adam Machanic‘s T-SQL Tuesday this month. Since Brent Ozar Unlimited‘s newsletter is about the only one I read … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments

SQL Saturdays

Sharpening my technical skills has been an ever-present goal since I started assembling computers for a guy named Dale around 1990. Over the years, some work better than others. There’s definitely nothing that can compare to hands-on experience, but that’s … 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

NULL Pain

I had an issue today that resulted in a tweet to #sqlhelp: #sqlhelp See Remarks section: http://ow.ly/Za6HX So how do you strip out 0x000? Suggestions? As it turns out, when you have a character string in SQL Server that contains … Continue reading

Posted in Uncategorized | Tagged | Leave a comment