I admit I took a guess at this one.

It was obviously going to be either 10, 10 (if the calculations were done in sequential order), or, if...

I would tend to agree with Jo Pattyn that latest is best.
Looking forward a bit though, my vote would go to that as-yet-nameless V.future which
1. Substitutes the error...

This theme reminds me of two quotes:

"The burned hand teaches best. After that, advice about fire goes to the heart." (from Lord of the Rings)
"Experience is a...

Thanks Steve and Luis for the enlightenment.

I was a bit hesitant to ask this question, but your answers have really helped a lot. There's a good atmosphere at...

Thanks Luis

That seems to work perfectly, and after getting my head around CROSS APPLY and the partition_stats DMV somewhat, I am beginning to understand why. Just checking though:...

Famous last words: "I just found the last bug!" Yeah, right. Hope springs eternal though.

Every piece of software, bar the most trivial, has bugs. And every piece of...

My train of thought on seeing this went domething like this... SQLPREF? Something odd there. Isn't it meant to be SQLPERF? Never actually used it, being more a developer than...

This is my sort of article. Starts off with a high level overview, says what it isn't as well as what it is, and gives some reasons why you might...

I have been looking at The BOL page for UPDATE again, and just noticed this remark well down the page, in a sub-sub-definition:

table_or view_name
Is the...