Ah, I didn't think the ID was counted, but as it's in every dataframe. I'll correct that.

Renaming the variable as well.

I sure do. Used to lose Internet out here. We were the max distance from the CO (around 19k feet) And there would be intermittent issues at times with either...

@rod

Normal has some odd definitions to people. When I worked in a mainframe environment, we knew thing were going down when everyone stood up in their cubes. This happened multiple...

I know a few people that like the Slack channel sending, which we even added to SQL Monitor at Redgate. I agree a central spot to get some alerts...

LAG is what I'd use as well, though really this is something we want to handle more in the front end as the positioning and rendering of the spaces in...

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