I know some of the authors of the Microsoft books. They're good. However, they do "teach to the test". This means it will help you pass the tests. However, it...

Why not just use SQL Dependency Tracker?

It does make the code harder to read though. While it doesn't matter from a technical or performance stand point with INNER JOINs as was already pointed out, it does...

Like Chris, show us the execution plan to get good advice.

One immediate issue,

November 27, 2018 at 6:02 am

#2014630

I don't know how it's extracting an MDF/LDF from the .BAK file (if it is). I assume it's possible because my company does some similar magic through one of our...

Tiny nit. Take away the calculation. Make it before in a local variable. It might lead to different row calculations. You are getting a VERY large disparity in estimated versus...

Sounds like you're trying to recreate the functionality from the Query Store. I'd suggest you take a look at this open source project. It may help.

I don't know which tool you're referring to. However, the command there is running an attach from an MDF and an LDF. You can't attach from a .BAK. You can...