Solomon Rutzky (5/5/2010)

---

Hey Paul. Actually, I had not had time to test the CROSS APPLY approach and was answering in terms of my solution against the simple WHERE clause...

Yes to the loop join - but that's exactly what is required 😉

Fetching the...

Hey Wayne,

How come your 2008 server is still at RTM? You're missing some pretty important fixes :crying:

Garadin (5/5/2010)

---

rajn.knit07 (5/5/2010)

---

Hello,

You have to write cursor here to update your lunchperiod data in class table from student table. First of all insert what ever data you have in class...

Are you sure Solomon? I would expect the APPLY + $PARTITION approach to be faster...

Today's Random Ward

My anti-virus package prevented me from downloading your post.

My (unrelated) thought for the day:

Oracle is really quite expensive and not half as good as they think...

Just faster in all scenarios eh? Sounds like magic!...

The second byte '01' is the sign. Can't think what the first byte is for 🙁

Paul, did...

I found a reference to back up my statement about LOBs using tempdb with INSERT:

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/02/04/what-are-the-bulk-import-optimizations.aspx

Question authoritative thinking.

Jonathan Kehayias and I just did! 😉

Thanks Wayne, that's very useful! My only remaining question is what versions of SQL Server (engine and SSMS) you are running. I guess they are similar to mine...

Hey Oleg, and...

It seems the glass is definitely half-empty for you guys tonight! 😛

I prefer to think of the glass as being massively over-specced for the task at hand.