I would start by tuning the queries.

If that doesn't work to remove the deadlocks, then and only then add a maxdop hint to those queries.

Server level, without knowing anything...

You only ever need to restore the last differential backup. They're differentials, not incrementals. Restore the full backup, the last differential then, if you're restoring log backups as well, all...

Someone's set up a DDL trigger and forgot to SET NOCOUNT ON in it.

Yup, that's intra-query parallelism

Tune the query so that it doesn't need to parallel (or just to get a more efficient plan) or put a maxdop hint on the query.

Michael Fried (12/13/2012)

---

I guess I would expect it to function more like a Microsoft Office program. When you save a document in Office 2003 Compatibility mode all 2007 or...

MSSQL_NOOB (12/13/2012)

---

I mean, if it's MSSQL2012 certification, then yes, I agree, a candidate needs to be recertify. But if it's the same MSSQL2008 - 70-432 exam (for example), why the...

When the log gets full, they will both grow. If the log is not full, then the files aren't going to grow. If you have 148 GB free in the...

Sch-M is a schema modification lock. Taken by the...

What am I supposed to be seeing there, other than 2 files of the same size?

You said in your initial post "both the logs are growing at the same rate....

Anything written by Itzik Ben-Gan

Exactly what it is doing.

It is...

Not really. Setting the DB to read only or single user for the duration of the backup is the simplest. The question...

There's no official list because many traceflags are undocumented or confidential. Microsoft is not going to go and document a list of undocumented traceflags

Yeah, that's pretty unrecoverable.

You may want to do some investigation of the IO subsystem, before it messes up again and corrupts the data file.

You can't commit it. It has to finish the rollback.

Trying to kill it will not cause a corrupt database (there is nothing that a user can do via T-SQL that...