So I'm a big fan of SARGability, which means I would take Scott's version and do it with a CTE.

WITH JobTypes AS (SELECT JobID, MAX(CASE WHEN TaskName...

• This reply was modified 9 months, 2 weeks ago by Brandie Tarvin.

Now watching Black Arts # 3 and I just have to ask..

Jeff, where do we get your f'n Tally Function. @=) (j/k).

But on a serious note, do you have that...

Wow. Just ... WOW. Watched the 1.2. Now going to watch 3.

Thanks, Jeff.

So I am doing some major learning today. And here I thought I could take it easy on the week of Turkeys! @=)

Thank you both. I have already forwarded the...

Oh, and can I get a favor? Can everyone to update their posts with the proper spelling of my name? Brandie.

Jeff, thank you for that information. I will research.

So we are using the Hallogren solution for index maintenace and yes, it involves reorgs. I removed reorgs from the servers I'm...

Jo, I have already read through both links you have provided in this chat. I am looking for white papers beyond this information.

EDIT: The application team member was very specific...

• This reply was modified 9 months, 2 weeks ago by Brandie Tarvin.

Stop rebuilding indexes.

Microsoft's documentation states:

Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should...

Thank you, everyone, for your input.

Now would a high-volume OLTP (lots of daily inserts or deletes or both) make a difference in your opinion?

Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?

I'm sorry. The post that was previously here was harsh. I am removing it because there was no call for me to sound so short.

Converting to uniqueidentifier did not work...

• This reply was modified 9 months, 2 weeks ago by Brandie Tarvin.

Kaj, that does work faster than the function I found via Google. THANK YOU SO MUCH!

• This reply was modified 9 months, 2 weeks ago by Brandie Tarvin.

There isn't really a need to use that scalar function for the conversion.

This will also work:

SELECT t.SPID, t.Status, t.ProgramName, j.name AS JobName
FROM @Table t
LEFT OUTER JOIN...

You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

SELECT *...

Weird gateway error caused repost. And won't let me delete the code block.

• This reply was modified 9 months, 2 weeks ago by Brandie Tarvin.