Category Archives: Uncategorized

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

IndyPASS is going Back to School

Yes, I’ve been quiet on this blog forever. That’ll change soon. I’ve been working on a couple of topics that I think may be of use to people other than me. But in the meantime, I’m presenting “Back to School: … 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

Albuquerque Redux

In just a few weeks, I’ll be back in Albuquerque for their SQL Saturday. My session this time is Adding Lightness, and is a thorough examination of how compression works in SQL Server. If you’re in the Albuquerque area and … 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

Yay #SqlFamily

It’s a big #SqlFamily week for me. Tonight, IndyPASS is having my co-worker, Eddie Wuerch, present on SQL Server v.Next. It’s the first IndyPASS meeting I’ve been able to attend in a while, and I’m looking forward to it. And … 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

Getting Better

When I (infrequently) post something here, it’s generally tech-related, and often specific to SQL Server. This one’s a little different. Throughout the last year and a half, I’ve improved my physical fitness dramatically, losing weight and exercising a lot. I … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SELECT INTO

I just came across a stored procedure that does something like this: DECLARE @stmt NVARCHAR(MAX); CREATE TABLE #foo (col1 INT, col2 INT, col3 INT); SELECT @stmt = N’SELECT col1, col2, col3 INTO #foo FROM bar;’; EXEC sp_executesql @stmt; The incorrect … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SQL Saturday #402 – Indianapolis

I’m once again presenting a session at a SQL Saturday, this time in my own backyard. SQL Saturday #402 is here in Indianapolis this Saturday. If you’re in the Indy area and spend any significant amount of time with SQL … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment