Lynn and Peso, thanks for jumping in, that's good advice.

I always forget about EXCEPT as it was new to 2005 and the majority of my experience has been in 2000. ...

Cool.

I actually did something several years ago for 7/2000 that used DMO to do that in ASP.NET 1.1.

Oh man, I was hoping for some kind of, this book was great I highly recommend it answer. Although I'm with Brent Ozar on this one. Not super...

Oh no! Not Powershell! I have enough trouble with T-SQL. 😀

Jeffrey,

Seriously, what have you used for resources to learn powershell?

I honestly think the best way to...

Yup. Nice catch. I totally braincramped on that one.

You can use a LEFT OUTER JOIN or WHERE NOT EXISTS or WHERE NOT IN. The method is really up to you.

I have typically used LEFT OUTER JOIN's for...

I think this blog post probably gets to the heart of your issue. It isn't exactly the issue you are seeing, but the clustered index scan is definitely causing...

Bob,

Here's another link that I used get an idea of how to submit my abstracts:

http://facility9.com/2009/04/02/pass-summit-call-for-speakers-8-days-left/

And here's my blog post about my submissions:

http://wiseman-wiseguy.blogspot.com/2009/04/pass-sessions-submitted-should-i-be.html

If you open query analyzer and do an sp_who does it show any blocks? What have you defined the size of the database and log files as?

Adi probably has the right answer. You could also query the default trace to see what is stopping the trace, like this:

SELECT

TE.*,

...

Mike beat me to the solution.

I do have to ask, why do you need to do this?

This is not mail, but here is a link for an RSS feed to KB's released for SQL Server 2005, http://support.microsoft.com/common/rss.aspx?rssid=2855&ln=en-us&msid=e58fb9c1a6e27644bdccf51620748c71. I'm sure there is one for 2008, I...

Definitely submit something Bob. Heck I submitted...

Can you run a trace and include the deadlock graph event? Then attach the trace file to the thread (zip and attach).

Thanks,