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...

Drove three hours to see it in the totality zone. Forecast was for partly cloudy,...

Thanks everyone for the responses. We see just here that different people like different things for different reasons at different times. It's all cool and I'm pleased you embrace it....