Tag Archives: sql

tsqllint

My PASS local group, IndyPASS, has its monthly meeting tonight. At my insistence, first-time presenter Nathan Boyd is showing off a SQL tool called tsqllint. Nathan, a coworker of mine at Salesforce, is the leading developer behind this GitHub project. … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

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

It Does Not Depend

A common refrain in the SQL Server community is the phrase, “It depends.” And, truthfully, that’s the correct answer to many questions. There are so many variables in any given situation that what works great 99 times will not work … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SELECT TOP 1 * FROM PASS.Summit2015;

I’ve been uncharacteristically quiet during this particular Summit. I picked up a cold on the way out there, which made the week a bit different than I was expecting. Still, I always take away quite a lot each time I … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment