An old-school, and effectively free, solution to this is setting up log shipping. However, that has received almost no love from Microsoft for years. The preferred method as was already...

Yep. A tested backup strategy is your single best means of recovery, without...

We're starting from a fundamental problem in the premise:

Can anyone explain why, when selecting data into a CTE and then using the results in the CTE to...

Strong, strong recommendation. Start learning notebooks. Also containers.

This message is actually most of the MVP Summit this year. Unlike other years, it's not a marketing message. This is...

The title says SSMS and the text says SQL Server. So, which is it? Are you trying to connect to SQL Server 2016 from SSMS 2012? If so, yeah, that...

Funny enough, that's one of my phone screen questions. I'd say anyone that has to do more than consume data from SQL Server really has to know this. It's one...

Thanks. With that, I'm back to my other recommendations. Your principals waits are on memory, so that's a likely problem. However, pick either DISTINCT or TOP 1, doing both is...

Why do you need DISTINCT when you have TOP 1? TOP 1 is going to ensure only one row gets returned. Eliminating the DISTINCT aggregation could help. I can't see...

where?