As someone else said, if the VM is NUMA aware, make the MAXDOP no more than the PHYSICAL cores in each NUMA node. For other configs (in any case actually)...

Did you fix anything?? Looks mostly the same to me, just fatter tables and now you have spills on the big HASH join and a bajillion row nested loop.

Alan.B (6/30/2016)

---

TheSQLGuru (6/30/2016)

---

Alan.B (6/30/2016)

---

Kevin said a lot of what I was going to say especially about fixing that sort with the tempdb spill - that's going to kill you. An...

Alan.B (6/30/2016)

---

Kevin said a lot of what I was going to say especially about fixing that sort with the tempdb spill - that's going to kill you. An index on...

1) What are all table create scripts. You are getting convert_implicits and I wonder if data types are all correct.

2) Stop doing the datalength > 0 thing. You need to...

I am sorry, but I can't figure out what you want here...

Please...

It would be nice to have some...

Which is why I said "if you can help it" about...

1) Is there a question here?

2) ALWAYS use WITH SCHEMABINDING when using UDFs, views and any dang thing else you can use it with! Build a box around the user,...

1) What you did (profile with spid filter) is perfectly fine and appropriate. I do this pretty much every single day of the year for lots of different clients. I...

Chitown (6/28/2016)

---

All DBs are online and in sync

This was the error in the log...

SQLAddict01 (6/28/2016)

---

Hi,

I am very much new to mirroring, I know how to set it up, but I don't know what to do when a principal server fails or the link...

What is the status of the other database? Is it suspect, offline or something like that?

YB makes a VERY key point: formatting stuff should be done outside SQL Server where at all possible!!! Don't waste any of the precious and expensive resources on your SQL...