but it had more USB ports, which I run short of.
Look into a USB hub....
Maybe it's not as "pretty damn good" as some anonymous internet commentators claim? Honestly?
It's honestly better than Access....
If lock escalation is your problem then lock escalation isn't the problem.
I did get around it by writing a custom implementation of the commercial module we were using for the particular transaction in question. It is true that the implementation sucked, but it sucked less on other DBs vs MS SQL, which just goes back to MS SQL sucks. I've had similar issues on Oracle and DB2, and neither of those went legs up under similar conditions like MS SQL. It's literally like driving off a cliff in a bus.
But, there's more to all this than simply how many cores. Are we SURE that the later CPU has less THROUGHPUT than the earlier one?
Yes, by almost 50%.
Honestly, I don't have the time to dig into it right now, but Intel keeps juggling number-of-cores, clock frequency, pipelining, and other esoterica in order to get the most favorable combination of performance per Watt. And often, as you noted above, it greatly depends not only on the TYPE of application; but also the DESIGN of that application, as to what matters, CPU-wise, and what really doesn't.
I only mentioned it to clarify in response to your question. If you're doing what I'm doing, those 2 "extra" cores matter. If you're only using it as a simple HTPC, perhaps not so much.
MS SQL server has its place:
Our competitors or enemies servers? A trashcan?
1: Oftentimes a company already has it licensed, so might as well use it.
Lemmings....
2: It is auditor friendly, with the pieces of paper (FIPS, etc.) that don't mean much in real life, but do mean a lot when ISO, or other audits happen, and you have to justify your existence and design decisions. (For those who say certificates/certifications don't matter, one place I worked actually had auditors that would fire people on the spot for "failing to have authority to run the equipment" if their RHCE/MCSE/CCIE certs lapsed.)
Sounds like a thankless place to work, but still doesn't support using MS SQL.
3: Finding MS SQL expertise is easy.
citation? Finding people who have seen MS SQL is easy, finding expertise, however, is as much or more limited than for other systems, mainly because most with real expertise won't touch MS SQL except when the business end of a pointy stick is poking them in the eye.
4: MS SQL does work and is decently secure. For 99.99% of tasks, it is just as good as Oracle.
This isn't to say that PostgreSQL is bad... but there are times where MS SQL is the ideal choice.
MS SQL barely works, and falls over as soon as it is hit with significant load. It's an old massive pile of crap essentially given to MS by Sybase, who mistakenly didn't believe anyone would be stupid enough to continue using that smelly pile when their new database was released. They severely underestimated MS's marketing prowess in this regard, and someone like you (an AC no less!!!) propagates the continuation of this incredibly terrible solution.
Those who can, do; those who can't, write. Those who can't write work for the Bell Labs Record.