There's no easy way to get that done, at all. Instead, you could reseed the identity to start at the max negative value and then let it increment naturally from...

Statistics out of date affect memory because the allocations will be wrong, causing all sorts of issues. If the stats suggest 1 row when 1 million will be returned, the...

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.