Rebooted old node and tried again after failover? I assume this is shared storage clustering, so the same master.mdf was scanned with dbcc?

If so, I'd fail back and try again....

Interesting discussion. I'm a fan of unit testing for a few reasons, but not "over testing". Test what you are working on, which might be alter the test.

Here's what I...

That's an interesting idea. Might be worth scanning those, though I'd expect you get some alerts when you apply patches. I haven't heard issues with SQL Server binaries, but I'd...

If someone is loading 27k rows into a dropdown, it can work for search/typing, but the render time might be high.

Any activity for the database should change the timestamp. DBCC does create a snapshot, which I'm guessing marks some sort of item in the file.

For others, use OUTPUT clause - https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-2017

Closing

Use a CTE to get the cartesian of unique employees, when left join.

I can't comment on this, but it seems like a file level filter driver, similar to what AV does. Those are not compatible with SQL Server and cause issues, especially...

There are some tools like DQS, but I think they are fairly similar. There is also MDS (Master DAta Services), which could help.  What are you looking for help with?

What...

Links should be fixed here.

Closing. Read answers here: https://www.sqlservercentral.com/forums/topic/convert-rows-into-columns-10

Nice set of uses and thanks for responding. I was hoping that more people would comment, but I suspect many people don't use them or know about them. Likely an...

I'm sure you'll do great. Looking forward to hearing how it goes.

We use the tinymce plugin for editing. This allows rich editing. Apparently, something on your system is blocking this.