I think they had an opportunity with this new Star Wars film. They could have opened right at the moment the last one closed. Everyone is celebrating their "victory". Suddenly,...

Yes!

With database designs that would make Codd break down weeping. They practically...

I assume a script (powershell or t-sql) and SQL Agent? That's how I'd do it.

Posting the solution would be helpful for anyone...

Thanks John, I was just starting to type a long screed.

Let me reinforce what John says. In SQL Server 2008 and better, you no longer need to implement trace flags...

If you're not seeing page latch waits as your number one wait type, by an enormous margin, then you should not be using the In-Memory tables & indexes. Period. They...

I don't know Dynamics well at all, so I did a quick search. Based on this, there are three possible timeout settings that you may need to adjust. I'd...

Happy Yuletide! Merry Christmas! Happy New Year!

Star Wars sucks (not the first two, chronological, films, just all the rest)!

Looking forward to going to see 1917 though.

RESTORE DATABASE name

WITH REPLACE, --if it's there already

MOVE 'file' TO 'x:\newfile.mdf',

MOVE 'log' TO 'z:\newlogfile.ldf'

Automate this.

However, I think Phil pointed out an excellent question, should development be occurring on a production...

Not necessarily replication. I'm very hesitant to ever suggest using that technology because it just doesn't get adequate support from Microsoft. No, instead, if you can write once and then...

Grant,

what would be a short checklist

of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...

Grant,

what would be a short checklist

of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...

It doesn't...

It's not always about performance. My company has largely stopped buying servers (I think, one in the last 6-7 years). Instead, we're hosting most things on VMs online, or in...

I'd focus on the queries to see what's causing the pain. Document it for the vendor. Also, maybe a judicious index or a plan guide could fix the issue. Capture...

By secondary I assume you mean a differential? Or maybe you mean a file or filegroup backup. If the first thing, nope. You're stuck without the primary backup. If the...