Afaik, Merge didn't make it into SQL...

Yup. I've seen some nasty stuff from vender software. From 38 indexes in one table, with the same leading column, to 'temporary' tables that don't get dropped (we had 150000...

Yeah, witness servers aren't exactly expensive. SQL Express and a desktop work just fine.

:hehe: 😉

Without a witness, mirroring won't...

Why the recovery interval?

Also what you can do is change the server-wide max degree of parallelism. I don't rcommend dropping it to 1. What I normally do is set it...

Come visit my neck of the woods. Christmas day here is...

We've all done it at least once.

I told a lot of people that truncate wasn't logged and couldn't be rolled back. Even mentioned that in some code reviews I did....

It's fine. Just to interpret the graph requires most of it. I'll note which lines say what, so that you can see how I read the graph. (I just numbered...

Jeff Moden (12/5/2007)

---

I've got my health, a great job, a great set of bosses (yeah, more than one), a wonderful Fiancée who is also my best friend, and a...

Please don't cross post. Continued here

http://www.sqlservercentral.com/Forums/Topic431592-149-1.aspx

The N signifies that the following value is unicode (nvarchar/nchar)

The LEN should return the same, the datalenght for the N-prefixed value should be twice that for the value without the...

Agreed. They, along with the index usage stats are among the first things I check when tuning.

I'm not sure I follow you. Can you post what you've tried and what error it gives please?

If you know little to nothing about indexing, the DTA may be a good place to start. It's better that the index tuning wizard was (but that's not saying much)

Personally,...

My guess is not. I've...

That doesn't look like the entire deadlock graph. Post the whole thing (in code blocks) please.

From the bit there, I can see the following.

The deadlock was between processes 130 and...