Tag Archives: sql

T-SQL Tuesday #106

This is a response to T-SQL Tuesday #106, Trigger Headaches or Happiness, by Steve Jones. I can only recall one time in the past several years (at least a decade) that I’ve found triggers to be useful. It involves data … Continue reading

Posted in Uncategorized | Tagged | 1 Comment

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