Since it's SQL 2005, can you get the deadlock graph using traceflag 1222 instead of 1204 please? The information's a lot more detailed and far easier to read.

Not true. Nested loops, merge and hash are the three algorithms that SQL uses to do joins. Nested...

For a summary: http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

For the really technical details, follow the links on that page.

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic630887-1063-1.aspx

RBarryYoung (1/6/2009)

---

GilaMonster (1/6/2009)

---

Which edition was that?...

GSquared (1/6/2009)

---

If the UDFs are the ones that you define a table variable for the output (called "multi-value UDFs"), then that's probably the biggest source of the performance problem. ...

< Shrug > Out of my area of expertise. Absolutely no idea.

Anything interesting...

kathyoshea (1/6/2009)

---

Create a new multi-statement table-valued function.

Select the data and use the order by in the loading of the table that is returned.

This works in all the testing I've done....

IO sub-system glitch? It's pretty much the only thing that comes to mind.

I assume there's all sorts of errors in the error log about 'cannot open file', etc.

Got a...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic630817-266-1.aspx

tfifield (1/6/2009)

---

Gail,

Wow! I never thought about the parallel problem. It gets uglier all the time. I'd have to tweak MAXDOP in order to guarantee that it was...

The source for an insert can be either VALUES or SELECT, not a combination.

Try this:

INSERT INTO tblProject...

In 2005/2008, the inserted and deleted tables are materialised from the row version store that's...

In that...

Marios Philippopoulos (1/6/2009)

---

DECLARE @ActionType char(1)

SELECT @ActionType = CASE

...