Thanks Grant. I really appreciate for helping me with this. Yes it is a classic deadlock problem . Actually we have only one table and just one simple update....

This is not a parallelism issue. Don't go messing with MAXDOP.

No, you're hitting a classic deadlock problem. You need to follow the link to that article I provided. What's going...

Statements can certainly be the same. The question is, what the SPID of the two processes? If they're the same, you're experiencing parallelism deadlocks. If they're different, it's just two...

As to the last film. How long have they known that they could launch a ship into space warp or whatever they're calling it and destroy every single thing in...

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