Viewing 15 posts - 286 through 300 (of 49,571 total)
Ah, I see what's happening.
There's a SELECT earlier in the (implicitly started) transaction that's taking a table-level shared lock. You're going to have to identify what that select...
March 3, 2018 at 9:41 am
March 3, 2018 at 9:05 am
March 3, 2018 at 9:00 am
Restore the last full backup before the data was deleted WITH NORECOVERY, then restore the last differential backup WITH NORECOVERY, then restore all log backups after that point WITH NORECOVERY,...
March 3, 2018 at 6:30 am
What are the settings for Allow_row_locks and Allow_Page_locks for that table?
An update of 3 rows, filtered by the clustered index should not be taking table locks.
March 3, 2018 at 5:58 am
Unless you take your backup WITH CHECKSUM, the verify just reads the header. It's pretty worthless.
March 2, 2018 at 2:55 am
March 2, 2018 at 2:43 am
Don't fiddle with your lock escalation or page/row lock settings unless you know EXACTLY what you're doing and why. You can cause some serious problems messing with those.
March 1, 2018 at 2:05 pm
March 1, 2018 at 11:02 am
Locking happens on a row, page or table basis, always within a single database. Blocking does not happen at the server or database level (unless you're doing server reconfigurations or...
February 28, 2018 at 3:15 pm
Not unless you want to break the log chain, compromise the DB's recoverability in the case of a disaster.
Restarting the log backups would have cleared the log, allowing...
February 28, 2018 at 12:47 pm
February 28, 2018 at 12:03 pm
The only thing you can configure there is the DB's recovery model, which affects how long log records are retained, and whether some operations will be minimally or fully logged.
February 28, 2018 at 12:00 pm
Viewing 15 posts - 286 through 300 (of 49,571 total)