And, it looks like the code is hitting this table, [CoreV2].[HCM].[Employee_Info_Master].[EmployeeInfoMaster_List_Name_Top] [emp_CA], over and over again. You shouldn't have to reference the same table repeatedly unless you're getting different data...

Woof!

You have a bunch of plan affecting conversion warnings. I'd look to those as a first step. Nesting views, having a view that calls other views which joins to views,...

Are you getting deadlocks, with a deadlock victim, errors and all that? Or, are you seeing excessive blocking and long wait times on queries, which is absolutely not the same...

Thanks everyone for your stories. And yeah, none of this is necessarily easy or doable all the time. However, through lots of personal experience, I believe this stuff is important.

Yep. What Perry says. Also, test enabling causality tracking to be able to correlate queries to the stats updates.

Generally, just measuring performance of the hardware under no load, is a bit of a waste of time. You're just checking, mainly, that the people who sold it to you...

That is a very long time for a rollback.

So, you did experience data loss. The transaction that was rolled back, whatever it was doing that took 30 hours to undo...

My last company did a lot of engineering and testing. One thing they found is that most computer hardware failures occurred during startup. Evidently computers can just run forever, but...

Perry and David, you know I agree.

What about the appliance argument? Namely, there's an application running on SQL Server 2008 & Windows Server 2003 that runs purely in-house and is not connected to the Internet....

Reading these posts makes me feel better about only having SQL Server 2016 (and an exit plan for it) and procrastinating over upgrading my Windows 8.1 tablet because it...

The beauty of code, over toilets, is that we can, if we choose, improve the code. Tougher to do with toilets.

I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you include...

...and how do I do that?  I don't mind taking the time, I just don't even know what step 1...

Please create sample data in a consumable format using the {;} Code button to include a script to create a TEMP table and insert data into that temp...