Post the plans for both queries and it might be possible to suss out what's going on.

Yes to all the stuff @leo-2.Miller states. We simply don't have the data we need to tell you what the solution is. I'm pretty sure you don't have the data...

The app may be handling the deadlock "gracefully" by retrying the failed process (try/catch) without the user even knowing, but ideally the app should be fixed to reduce the...

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