You've got an active transaction. A session somewhere has run a BEGIN TRANSACTION and has not either committed or rolled the transaction back.

Commit or roll back the open transaction, then...

Igor Micev (12/30/2014)

---

Hi Gail,

I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't you...

goussarova (12/30/2014)

---

Hi Gail,

No, I have no proof of page locking.

I have not considered read committed snapshot or snapshot isolation as I never used them before.

I read about snapshot isolation this...

Backup/restore - backup the database to a file. Restore from file.

Copy database wizard - run object creation scripts on destination and copy data one table at a time.

SELECT * FROM TableName WHERE DateTimeColumn = '2014-12-28 08:52:02.920'

Not entirely true. Mirroring up-version...

matt.newman (12/12/2014)

---

The only thing I could attempt is breaking log shipping, which I would prefer to avoid. Or, kill maintenance for a night to slow all transactions to speed the...

The same way as in this thread of yours http://www.sqlservercentral.com/Forums/Topic1646925-149-1.aspx, you can just omit the LEFT function since you're grouping by the entire column

Please don't post multiple threads for the...

Not enough information there. The CheckDB output would have been written to the error log. Look there.

IncidentalProgrammer (12/29/2014)

---

They've given me my own exclusive space to play with. I checked and rechecked to make sure of that, because I was worried I might bull-in-a-china-shop it, and break...

IncidentalProgrammer (12/29/2014)

---

Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that to restore, all...

goussarova (12/29/2014)

---

As Gail Shaw mentioned, since the sql will always place an exclusive lock, and since every machine updates its own record, may be I should use row locking instead...

Why do you think you need to do anything?

No ORDER BY, no guarantee of order. End of Story

If you need a particular order, put an ORDER BY on your query.

Uwe Ricken (12/29/2014)

---

SELECT, INSERT, UPDATE, DELETE are definitely not always single threaded. They can all run in parallel when the optimiser decides that the plan is expensive enough (compared with...