I'm not sure I'd say that this is going to help performance, not because I'm against normalization, I'm very much in favor, but because I'm unsure of the root cause...

And, to determine what value to set your Threshold to, I'd take this approach or something like it.

However, that's for parallelism, which is much more often seen a choke...

Given this situation, yes, statistics maintenance should be the top of your list. Also, adjustments to the default settings of SQL Server. They're not always great. Cost Threshold for Parallelism...

So, please, I hope, you're testing this in a non-production environment, because, here's a bit of fun trivia, once you mark a database as in-memory, you can never undo that,...

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the time.

This sounds...

Thanks for your response .

I tried your query yesterday ( 19/02/2020 ) and use this command : WHERE last_execution_time >= '2020-02-15'

The result that I got is the records starting...

Ah, the big data clusters. Those are wicked cool. Also, they're not Availability Group technology. Well, I'm sure some is utilized. However, it's not a traditional AG. Instead, that's a...

Agent.

I can't imagine...

Shockingly, the man who hasn't even played with R for a year got this one wrong.

You can. I'd suggest you read through the documentation for some of the how to. Don't bother with model (unless you're a unicorn and you're putting customization in model...

Minimize the amount of index reorgs you do. Most of them, most of the time, are actually unnecessary. Instead, focus on getting the right page free space and let the...

You can restore 2012 to 2016. It'll work fine. However, once it's moved to 2016, you can't backup and restore back to 2012. So, this is likely a permanent upgrade...

First up, look to your wait statistics. If you're not seeing IO_LATCH* waits as your number one wait (and number two, three, four...), chances are extremely high that going to...

Personally, I wouldn't do this from within SQL Server. Instead, I'd set up a PowerShell script to make all the connections. It can still save it all back to a...