UDFs (Scalar and Multi-statement Table Valued Functions) are UNBELIEVABLY BAD!!!! If you want some details, grab a copy of the SQL Server MVP Deep Dives 2 book (proceeds go to...

Often a query as complex (and potentially WICKEDLY suboptimal) can take many hours to tune. Fortunately for you there seems to be a magic-bullet: and vru.Full_User_Name0 IN (@Assignee)

So with...

If you want to monitor SQL Server or diagnose MANY issues, you MUST get Glenn Berry's SQL Server Diagnostics Scripts.

here is a spiffy query from there to see CPU history...

Eirikur Eiriksson (4/12/2016)

---

TheSQLGuru (4/12/2016)

---

The default of 5 for cost threshold for parallelism is almost universally too low. I don't know of a formula for setting a higher value, but I...

Make sure tempdb is identical, and beefy!!

I had a client that switched from Win 2012 to 2012R2 server and had a BAD experience with it and SQL Server. They actually...

Argenis Fernandez has some great stuff out there about how to make checkdb run faster, along with Paul Randal.

Check patch level. There were numerous fixes for checkdb.

My question is...

The default of 5 for cost threshold for parallelism is almost universally too low. I don't know of a formula for setting a higher value, but I know pretty much...

Like I said, you have to have enough room to write the checkpoint stuff. 🙂

tlog of tempdb is more like it.

LOTS of potential culprits here. Got to observe...

I don't think CHECKPOINT will help with a full tempdb. Maybe a transaction log (but likely not then unless there is enough room to write a bit of stuff about...

It is critically important to gather as much forensics as possible before pulling the plug. Often with good diagnosis the sledge-hammer approach isn't even necessary. But regardless, if you...

Sergiy (4/7/2016)

---

Every record must fit into a single data page.

A data page is...

Excellent!

select from your hours table

left join to your job status table

use CASE WHEN js.something is null then 'failed' else 'succeeded' end as jobstatus

this works because on the left join...

Well, if you are duplicating them in a temp table unnecessarily then they could be an issue. Of course updating rows isn't free either, especially when you make them larger...

No worries mate. I sure wish those were on by default!