It'll do the job. It's not how I'd do it. I would capture the metrics through extended events. The reason for this is, depending on where you run it and...

This is not a homework service. We'll help. We won't do all the work. Try it. Tell us where you get stuck. Show your work. We'll help you fix it...

Without the structure and the execution plan, I'm guessing here.

Yes, if you're trying to squeeze more performance, a covering index may be the way to go.

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