March 1, 2010 at 10:58 pm
Paul - good article.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 2, 2010 at 1:52 am
CirquedeSQLeil (3/1/2010)
Feet were created to kick balls.
And I thought they were for kicking a$$ π
Go figure :rolleyes:
Far away is close at hand in the images of elsewhere.
Anon.
March 2, 2010 at 3:52 am
CirquedeSQLeil (3/1/2010)
Paul - good article.
Thanks Jason. I think it's pretty much ready for publication now, just waiting for the last couple of reviews to come in (hint hint).
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 5:47 am
CirquedeSQLeil (3/1/2010)
Feet were created to kick balls.
No disagreement here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 2, 2010 at 5:57 am
Paul White (3/2/2010)
CirquedeSQLeil (3/1/2010)
Paul - good article.Thanks Jason. I think it's pretty much ready for publication now, just waiting for the last couple of reviews to come in (hint hint).
Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train into work yesterday, the impression I have is of a thoroughly researched and well-understood piece of rock-solid technical work written in a lucid and easily digestible format for an eager audience.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 2, 2010 at 6:42 am
Chris Morris-439714 (3/2/2010)
Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train into work yesterday, the impression I have is of a thoroughly researched and well-understood piece of rock-solid technical work written in a lucid and easily digestible format for an eager audience.
Were you drunk at the time? π :laugh: π
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 6:48 am
Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train into work yesterday, the impression I have is of a thoroughly researched and well-understood piece of rock-solid technical work written in a lucid and easily digestible format for an eager audience.Were you drunk at the time? π :laugh: π
Not at 7.40am no, but I will be when the beer you promised turns up π
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 2, 2010 at 6:51 am
If you're giving away beers.....we could use a few here at the ranch. π
March 2, 2010 at 6:54 am
Chris Morris-439714 (3/2/2010)
Not at 7.40am no, but I will be when the beer you promised turns up π
Ha! Has it been chilly in Hβ¬ll recently then?
On a serious note, I'm happy with that as a review for the Sequence Table, given the detailed feedback from others already...the article on APPLY is ready too - would you prefer to review that on Thursday evening? I'm just looking to make best use of the time you have available. π
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 6:57 am
Steve Jones - Editor (3/2/2010)
If you're giving away beers.....we could use a few here at the ranch. π
Always happy to provide free beer for the esteemed denizens of SSC. It'll be waiting on the bar at the Hummer any time you're all ready. Just mail me from there when you're ready - it's two minutes walk for me :laugh:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 7:07 am
Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
Not at 7.40am no, but I will be when the beer you promised turns up πHa! Has it been chilly in Hβ¬ll recently then?
On a serious note, I'm happy with that as a review for the Sequence Table, given the detailed feedback from others already...the article on APPLY is ready too - would you prefer to review that on Thursday evening? I'm just looking to make best use of the time you have available. π
Paul
Chortle - tight git!
Sure thing, an article on CROSS APPLY would be perfick, send it over. Is this the APPLY that has an automagical cardinality alignment effect or the regular one? Don't answer that :blush:
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 2, 2010 at 7:15 am
Chris Morris-439714 (3/2/2010)
Sure thing, an article onCROSSAPPLY would be perfick, send it over. Is this the APPLY that has an automagical cardinality alignment effect or the regular one? Don't answer that :blush:
Sent. Thanks!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 7:37 am
Paul White (3/2/2010)
Sent. Thanks!
You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what are the restrictions?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 2, 2010 at 8:26 am
Chris Morris-439714 (3/2/2010)
You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what are the restrictions?
I'm kinda in two minds about this - I hope you can appreciate why.
On the one hand, I'm very flattered that you think it's worth passing on.
On the other hand, it should be published here soon, and it was just a copy for review really. I guess I think it'd be nice if your colleague saw it on SSC first maybe?
Am I being unreasonable?
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 2, 2010 at 8:29 am
Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what are the restrictions?
I'm kinda in two minds about this - I hope you can appreciate why.
On the one hand, I'm very flattered that you think it's worth passing on.
On the other hand, it should be published here soon, and it was just a copy for review really. I guess I think it'd be nice if your colleague saw it on SSC first maybe?
Am I being unreasonable?
Paul
Having thought about it...yes, you're absolutely right Paul and I apologise for putting you on the spot there. You beat me to it.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 12,151 through 12,165 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply