APPLIED to two instances but I think both were on "node" 2 when patched, so none patched while sitting on "NODE" 1

The fact that one of the patched instances...

Cluster Events show entries like this which probably occurred when trying to move this instance to the patched node. Moving it back to it's original node makes everything ok.

Cluster...

I'm running the sql 2012 install "add node to cluster" -- hopefully this will do it.

Odd thing that Microsoft refers to an instance as a "node" when everywhere else...

Absolutely correct. I don't know why we don't have load tools so that a prod-like load can be tested in QA. The need has been there for years.

I was just suggesting that hardware expenditures ( assuming the company has the funds ) is quicker than serious code re-engineering AND keeps development focused on all of those new...

Is this relevant? Hardware may be cheaper than experienced developers and DBAs who could actually develop the sophisticated procs which could handle complicated business logic.

In many of these highly...

Possibly off-topic but here is an exchange I had yesterday with a developer on ORMs, TVPs, abuse of the "IN" operator, huge amounts of update statistics and poor cardinality estimates...

What Lynn said 🙂

Erland's article may not be current. In discussing TVP's and the ability to use them with Entity Framework, one of our developer's pointed out the article below. However,...

It can definitely become a "hot mess." The main database has now grown to 5TB and combines OLTP with OLAP-reporting style queries. I shouldn't blame everything on...

We started an application many years ago with .NET/C# and ORM technology ( and no DBA ). Over the years it continued to perform largely due to hardware...

Almost all of our application code is ORM-generated, originally in C# code. ( entity framework type stuff )

Are you saying the table/column aliases etc actually have a bearing on performance?...

I see two other similar plans in the cache with a high number of executions/uses and quick runtimes. This bad boy has only one use and slow runtime. ...

This appears to be one that runs in the middle of the night only. 226 seconds last night. Since we're in the process of adjusting cost threshold...

Attached the plan