February 23, 2010 at 9:52 am
Are we geeks or not?
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
February 23, 2010 at 9:52 am
GilaMonster (2/23/2010)
Are we geeks or not?
Yes.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 23, 2010 at 9:58 am
Looks like Gus is mister 12000.
Gus, you get to buy the first round. See you at Cheers. š
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 23, 2010 at 10:21 am
Missed another one - it always approaches a milestone when I have to get on the road - dang it.
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
February 23, 2010 at 11:03 am
I posted my solution to the FizzBuzz challange on AskSSC. :smooooth:
February 23, 2010 at 11:46 am
Lynn Pettis (2/23/2010)
I posted my solution to the FizzBuzz challange on AskSSC. :smooooth:
Check your email.;-)
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
February 23, 2010 at 2:38 pm
WayneS (2/22/2010)
RBarryYoung (2/22/2010)
Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told me about this?!?! :w00t::w00t:Congrats. Maybe you should be writing that column...:-)
Heh, not likely. š While I may not agree with Itzik on everything, he's a far better SQL Columnist than I could ever be. I could no more take over his column than I could take over Martin Garnder's (though I sure do wish that someone would do that second one š )...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 2:41 pm
Paul White (2/22/2010)
Steve Jones - Editor (2/22/2010)
You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.Be sure to include some pictures of sheep for your tally table. š
Aha! Ho ho ho. Sheep - I get it. :laugh: š ;-):satisfied: :blink: :doze:
Why do Ozzies (Ozzites? Ozzians? Ozmen?...) also think that jokes involving sheep are funny? I never did get this ... š
On a separate subject, I'm finishing one concerning Sequence Tables. I'm just trying to anticipate the main objections. Aside from concurrency concerns, does anyone have any comments? PM me if you feel inclined - I'd appreciate anything at this stage, feel free to go hard on being the Devil's Advocate š
Umm, I fear I'm being dense, but what is one?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 2:43 pm
Paul White (2/22/2010)
RBarryYoung (2/22/2010)
Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told me about this?!?! :w00t::w00t:Well done. I haven't been following the series (even though I subscribe - no time!) so I can't say anything more effusive at this stage. I'll definitely take a look tonight. You're getting to be quite famous, it seems :w00t:
Ennh, "famous", "infamous", its a fine line. š
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 2:46 pm
Paul White (2/22/2010)
CirquedeSQLeil (2/22/2010)
With him becoming famous, we're starting the push for him to be MVP.Well I don't know exactly what the criteria are, but Barry strikes me as a strong candidate from what I've gathered about the award, illness notwithstanding. I know technical proficiency isn't really key to the award, but it would be nice to replace some of the, er, less technically gifted current MVPs with people like Barry.[/contentious]
Ennh, "technically proficient", "contentious", it's a fine line. š
( ... is there an echo in here?)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 2:49 pm
GilaMonster (2/23/2010)
Are we geeks or not?
Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
February 23, 2010 at 2:53 pm
Gianluca Sartori (2/23/2010)
RBarryYoung (2/22/2010)
Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told me about this?!?! :w00t::w00t:Crap! It's subscribers-only! I can't read it, but congrats Barry!
Here's the line (*):
Itzik Ben-Gan, "Calculating Concurrent Sessions, Part 3" (SQL Server Magazine, March 2010)
... In a benchmark test that I ran, it proved to be an order of magnitude faster compared with New Set-Based Solution 1. Iād like to thank Ben Flanaghan, Arnold Fribble, and R. Barry Young for coming up with the new solution. ...
(*: Steve, I am pretty sure that this falls under "Fair Use" guidelines. Feel free to edit it out, if not.)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 3:00 pm
Elliott W (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
By derivation, a "geek" is someone who bites the heads off of live chickens in a circus sideshow, while a "nerd" is a socially awkward person with a scholarly personality.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 23, 2010 at 3:03 pm
Paul White (2/23/2010)
RBarryYoung (2/22/2010)
Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told me about this?!?! :w00t::w00t:... Even so, I can't help thinking that this is another case where the T-SQL hammer is the wrong tool for the job. I have a CLR saw in my toolkit that just might cut this particular board more efficiently: after all, the requirement is just a slightly funky aggregate, isn't it? ...
Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if a CLR solution come overcome the "call per row" penalty.
As for the old Hammer saw (:-P), I actually would defend SQL as an appropriate and even preferred solution for this problem (barring really significant performance differences).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2010 at 3:07 pm
GSquared (2/23/2010)
Elliott W (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
By derivation, a "geek" is someone who bites the heads off of live chickens in a circus sideshow, while a "nerd" is a socially awkward person with a scholarly personality.
I can live with that.
CEWII
Viewing 15 posts - 12,001 through 12,015 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply