Partitioning, first and foremost, is a data management tool, not a performance tool. We must be up front and clear with this. If you partition any tables, let alone every...

Hey All,

Steve's on the road in Australia, so I'll let him respond here when he gets around to it. I just wanted to let you know why you might not...

Thank you Grant for bringing up the important subject of self care. There are numerous youtube videos that you can find on the subject. But they all seem to...

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.