Thanks Grant.

I've looked at the plan again, and the query is left joining to the table that has the index seek/lookup (not every row on the outer side of the...

I have the book, its well worth reading.

I finally did manage to get hold of a copy - from Grey Matter[/url].

Service Broker takes some getting used to, and you really do need to bite the bullet and learn it, otherwise you won't be able to support or troubleshoot your solution,...

Its listed on Amazon UK (and has been for some time), but it seems permanantly stuck with "Currently Unavailable". While I can see it in stock on Amazon US, when...

Have you tried profiling your ssms session to find the proc?

I haven't found the implementation of clr too difficult, but then i'm as much a .Net programmer as a Sql Developer.

As suggested, i wouldn't do anything using the clr that couldn't be done easily and efficiently using TSQL. However, I've found that clr functions can be very useful - One...

I have on occasion used an ordinal for sorting, only for adhoc stuff though, not production code.