June 23, 2009 at 3:06 pm
Congrats Flo.... π
You get to host the Party...:-)
-Roy
June 23, 2009 at 3:07 pm
Florian Reischl (6/23/2009)
GilaMonster (6/23/2009)
He offered $5.:laugh:!
Did you answer this?
I replied with my actual hourly rate (which seems lot to US people because of the exchange rate). Never heard back.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2009 at 3:12 pm
@roy: You just have to come to Germany.
@Gail: (S)He will answer when (s)he really gets performance problems. π
How to Post Data/Code to get the best Help How to Post Performance Problems
June 23, 2009 at 3:14 pm
RBarryYoung (6/23/2009)
Nope, that's right. Run it and see. π
Well I did try! :ermm:
Once I have removed the line numbers and line breaks, I get this:
declare @S nvarchar(999) Set @S='Ε''~β,ROWS~β¬ΕΕ~}and~|le~{char(1~\e ~Q Se|ct ~Jexec sp_~4 BEGIN /$ 6 Jspaceused &Ε?&&,@where}=β¬} o.namot lik\&Ε#[0-9]%&&,@postcomm}=6tQdb_name(),*: De|te:β¬ END Ε, Ε^ΕQTOP 5 BAS\,[$] ,7β:t orderby cast(|ft(7,|n(7)-3) as int) desc<' ASCII(@s)99SELECT @S=REPLACE(Right(@s,Len(@s)-(Charindex('~',@s))),left(@s,1),substring(@s,2,Charindex('~',@s)-2))
EXEC(@s)
[font="Courier New"]Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ASCII'.[/font]
Am I being thick here?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 23, 2009 at 3:19 pm
Florian Reischl (6/23/2009)
@Roy: You just have to come to Germany.
Hey Flo, remember: I'm not too far away...
Let me know where and when. I'd assume an "Oktoberfest" invitation with accommodation and beverages included would just be appropriate π
I'll cover my travel cost π
Anybody else ready to join?
Edit: btw: Congrats! π
June 23, 2009 at 3:21 pm
Florian Reischl (6/23/2009)
:-):hehe::-D:-):hehe::-D6000
:-):hehe::-D:-):hehe::-D
@Paul: Probably looks better in IE or Firefox π
WE ARE LEGION!!!!
June 23, 2009 at 3:25 pm
RBarryYoung (6/23/2009)
It looks like my code got partially garbled when they tried to format it for the article. I have attached the actual code in a text file for your enjoyment. π
:laugh:
The in-line version became slightly garbled too!
declare @S nvarchar(999) Set @S='Ε''~β,ROWS~β¬ΕΕ~}and~|le~{char(1~\e ~Q Se|ct ~Jexec sp_~4 BEGIN /$ 6 Jspaceused &Ε?&&,@where}=β¬} o.namot lik\&Ε#[0-9]%&&,@postcomm}=6tQdb_name(),*: De|te:β¬ END Ε, Ε^ΕQTOP 5 BAS\,[$] ,7β:t order by cast(|ft(7,|n(7)-3) as int) desc<' WHILE ASCII(@s)99SELECT @S=REPLACE(Right(@s,Len(@s)-(Charindex('~',@s))),left(@s,1),substring(@s,2,Charindex('~',@s)-2)) EXEC(@s)
[font="Courier New"]Msg 173, Level 15, State 1, Line 1
The definition for column 'BASvarchar' must include a data type.[/font]
Luckily, the attachment worked just fine, and is just outrageous - but so cool.
Appreciating it is one thing - understanding it will have to wait until after work π
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 23, 2009 at 3:25 pm
lmu92 (6/23/2009)
Let me know where and when. I'd assume an "Oktoberfest" invitation with accommodation and beverages included would just be appropriate π
Accommodation for Oktoberfest should be okay. I cannot guarantee the beverages but I know people who know people π
How to Post Data/Code to get the best Help How to Post Performance Problems
June 23, 2009 at 3:32 pm
Florian Reischl (6/23/2009)
@Paul: Probably looks better in IE or Firefox π
Oh - ha ha ha π
Actually it renders just fine in Chrome 2 - albeit somewhat faster than in Internet Exploiter or FireFix π
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 23, 2009 at 3:38 pm
Florian Reischl (6/23/2009)
@Roy: You just have to come to Germany.
How far are you from Berlin? There's a very, very, very, very small chance that I may be in that area in Nov.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2009 at 3:38 pm
Paul White (6/23/2009)
Florian Reischl (6/23/2009)
@Paul: Probably looks better in IE or Firefox πOh - ha ha ha π
Actually it renders just fine in Chrome 2 - albeit somewhat faster than in Internet Exploiter or FireFix π
Nothing against Chrome. I like it, the only really missing feature is "mouse gestures" in my opinion. I cannot work any more without this geek toy.
Just remembered a thread about two month ago, you posted some code with font size 5 (I think). It looked fine in Chrome as you wrote but it hurt in eyes with any other brother.
Edit: LOL. "Brother" should be "browser" π
How to Post Data/Code to get the best Help How to Post Performance Problems
June 23, 2009 at 3:39 pm
Oh boy. So now "standard SQL" has been invoked.
Jeff's gonna absolutely love this - I just hope Carl likes pork.
http://qa.sqlservercentral.com/Forums/FindPost740591.aspx
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 23, 2009 at 3:40 pm
Florian Reischl (6/23/2009)
Just remembered a thread about two month ago, you posted some code with font size 5 (I think). It looked fine in Chrome as you wrote but it hurt in eyes with any other bowser.
Lol yeah.
Like this? (size 3)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 23, 2009 at 3:41 pm
GilaMonster (6/23/2009)
Florian Reischl (6/23/2009)
@Roy: You just have to come to Germany.How far are you from Berlin? There's a very, very, very, very small chance that I may be in that area in Nov.
About 600km (almost other side of Germany). Let me know if you come to Berlin. Maybe I'll visit some friends there.
How to Post Data/Code to get the best Help How to Post Performance Problems
June 23, 2009 at 3:45 pm
Paul White (6/23/2009)
Florian Reischl (6/23/2009)
Just remembered a thread about two month ago, you posted some code with font size 5 (I think). It looked fine in Chrome as you wrote but it hurt in eyes with any other brother.Lol yeah.
Like this? (size 3)
Yep. And thanks for quoting my "bro
er" typo... :hehe: Just edited my previous post.
How to Post Data/Code to get the best Help How to Post Performance Problems
Viewing 15 posts - 6,001 through 6,015 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply