Yeah, I was going to recommend SQL Compare from Red Gate too. There's also Apex SQL, they have a nice compare utility. Visual Studio Team System Database Edition comes with...

Nice article over here:

http://jmkehayias.blogspot.com/2008/09/monitoring-for-blocked-processes-on-sql.html

Interesting, but I'd need to read this on in more detail to see if it's really good:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1162653,00.html

Nice one from MS on technet

http://technet.microsoft.com/en-us/magazine/cc434694.aspx

Your options are severely limited.

First, check the execution plan. Identify where the scans are occurring, if any, and see if you can affect them with an index or three. Think...

GilaMonster (11/23/2008)

---

Grant Fritchey (11/23/2008)

---

Actually, pretty desperate, the deadlock chapter comes up in two weeks! You may see me attempting to answer a few of the deadlock posts as they come...

Jeff Moden (11/23/2008)

Heh... no... haven't seen one like this before. The tools that generate code like this one and like Hibernate are gettin' kinda spooky and I've always resisted...

Jeff Moden (11/23/2008)

---

Grant Fritchey (11/23/2008)

---

I took a couple of minutes and laid out the TSQL so it was readable (may the gods keep & protect Red Gate & SQL Prompt)....

Ah, true, I hadn't thought about that. Still, the execution plan can point out where an index might help. He might be able to use a plan guide but I'll...

The DTA can be a somewhat useful tool, but it's not terribly reliable.

Do you have an execution plan for the query? That would help identify what's occuring within your system.

First...

Jeff Moden (11/23/2008)

---

Grant Fritchey (11/23/2008)

---

OK. I just read through all the posts. I can probably go with the AD phrase above because of the guys (I assume it's a guy)...

GilaMonster (11/22/2008)

---

It wasn't completely packed out. There were empty seats. I'd say the room was 50-60% full. Bob Ward's session in...

Re-writing one....

And yet, there is Gail, answering his questions... Amazing. I wouldn't even bother with a response on one like that.

I'm too busy to learn how to keep the log from growing? No. I'm actually not too busy to learn that one. I'm too busy to learn how to figure...

Jeff Moden (11/22/2008)

---

Ok... Going way back to the original post on this thread, lemme ask what you folks think... read the original post on the following thread... don't read the...

Jeff Moden (11/22/2008)

---

Ok... Going way back to the original post on this thread, lemme ask what you folks think... read the original post on the following thread... don't read the...