InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 20:55:51 GMT20http://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]Roy Ernest (10/18/2011)[/b][hr][quote][b]Jeff Moden (10/18/2011)[/b][hr][quote][b]bitbucket-25253 (10/17/2011)[/b][hr]Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirtThanks for all you have done to teach myself and countless others.[/quote]Thanks Ron. I met all 3 of the folks that hold the award from previous years and they're all great folks. The first one, Dan McClain, is a day older than dirt so, no pun intended, we've got things pretty well covered age-wise. :-D[/quote]You need someone as young as me to put you all in your place. :-D[/quote]Now, now mind your manners in the presence of your elders ... (Just kidding)Tue, 18 Oct 2011 10:04:11 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]Jeff Moden (10/18/2011)[/b][hr][quote][b]bitbucket-25253 (10/17/2011)[/b][hr]Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirtThanks for all you have done to teach myself and countless others.[/quote]Thanks Ron. I met all 3 of the folks that hold the award from previous years and they're all great folks. The first one, Dan McClain, is a day older than dirt so, no pun intended, we've got things pretty well covered age-wise. :-D[/quote]You need someone as young as me to put you all in your place. :-DTue, 18 Oct 2011 08:39:25 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]Steve Jones - SSC Editor (10/18/2011)[/b][hr]Congrats again, Jeff, and a nice ceremony for you and a nice speech from you. The award was well deserved.[/quote]You and Red Gate sure do know how to throw a party, Steve. Thanks for everything you've done over the years as well. I did manage to get the piece of reebar Rodney presented me with home. That was way too funny to leave in Seattle.Tue, 18 Oct 2011 08:25:09 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]bitbucket-25253 (10/17/2011)[/b][hr]Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirtThanks for all you have done to teach myself and countless others.[/quote]Thanks Ron. I met all 3 of the folks that hold the award from previous years and they're all great folks. The first one, Dan McClain, is a day older than dirt so, no pun intended, we've got things pretty well covered age-wise. :-DTue, 18 Oct 2011 08:22:28 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongrats again, Jeff, and a nice ceremony for you and a nice speech from you. The award was well deserved.Tue, 18 Oct 2011 08:15:53 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxJeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirtThanks for all you have done to teach myself and countless others.Mon, 17 Oct 2011 19:04:10 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxThe award ceremony in Seattle has come and gone. It was absolutely awesome especially since I got to put a check-mark next to some folks' names on my "bucket list" thanks to them being at the SQLServerCentral PASS Party where the award was given.Thank all of you again for the great honor you've given me.Mon, 17 Oct 2011 18:32:20 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulation Jeff. Thanks for your articles as well.Tue, 20 Sep 2011 19:28:36 GMTStanley Chanhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations on a very well-deserved recognition!JulieTue, 20 Sep 2011 14:35:33 GMTJulie Breutzmannhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff !!!Sun, 18 Sep 2011 20:44:10 GMTDanMcClainhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxI sure do appreciate all the great feedback you good folks have given. It's been my pleasure to serve.Sun, 18 Sep 2011 12:04:01 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations, Jeff. I have read some of your work and we've even conversed over development standards. I've tried to employ everything I have learned from you and have become an anti-REBAR evangelist.A well deserved honor. Please keep up what you are doing. The entire SQL community benefits from your attitude, knowledge and dedication.Cheers!Fri, 16 Sep 2011 11:06:07 GMTG Bryant McClellanhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxJeff - Congratulations! Truly a well deserved award. I can easily say that your articles / posts have had a significant impact on my skills as a DBA, which is, of course, why you do what you do. Thank you!Thu, 15 Sep 2011 13:58:44 GMTDavid Benoithttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff! I love to see when someone like yourself who puts in the work and the extra time to help people like me is recognized. Look forward to meeting you at PASS.Thu, 15 Sep 2011 09:54:19 GMTJohn Dempseyhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations - well deserved. Always learn something new when reading your articles. :-)Thu, 15 Sep 2011 04:05:31 GMTgsc_dbahttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations :)And thank you for all your help.Thu, 15 Sep 2011 03:23:27 GMTdmoldovanhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff, well deserved. I know you went above and beyond in some help you gave me in reviewing an article.Wed, 14 Sep 2011 16:43:22 GMTPatrick Cahillhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff! You are certainly very deserving of this award and, like others here, I am surprised it hasn't happened before. Your numbers table and anti-RBAR information changed my SQL Server world! Wish I was able to get to PASS and congratulate you in person.Cheers,Wed, 14 Sep 2011 16:04:47 GMTNicole Bowmanhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongrats Jeff! Hardly a surprise, given that he not only works but writes exceptionally understandable articles explaining the intricacies of SQL and set-based theory. A well-deserved recognition!Wed, 14 Sep 2011 15:51:30 GMTFargoUThttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxWOW! I don't know what to say, folks! I still can't believe this actually happened (the award... not the dust bunny party)! I even got a reply from Sushila, Remi's and my long lost and dear friend! (Hi, Sushila!).Thank all of you for the wonderfully kind words and the incredible work all of you do. This is an incredible honor for me because, whether you're a contributor or someone with questions, you good folks are the ones that made it happen. Thank you from the bottom of my heart for the opportunity to both teach and learn!I wish I could meet every one of you in person. I, apparently, have a party to go to on Tuesday night at PASS. If you make it to PASS and the SQLServerCentral party, please look me up so I can shake your hand and thank you. If you're going to PASS and can't make the party, I'm going to try and sign up to be available for "Ask the Expert" and the "Birds of a Feather" luncheon. Please stop by then. It'll be my honor to meet you.I'll also be going to the "Networking" party that Andy and Steve have put together for Monday night. Not much is better than doing some 12 ounce curls with old friends and new!Thanks an awful lot, again, folks. There is no way any of this would have been possible without you. And, no… no big head. I know where my roots are and you folks are it.Wed, 14 Sep 2011 14:19:49 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxMost Excellent - Congrats Jeff.Wed, 14 Sep 2011 13:08:42 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongrats Jeff ;-)Wed, 14 Sep 2011 12:08:33 GMT@SQLFRNDZhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations !!Wed, 14 Sep 2011 11:49:05 GMTBlueTigerhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff, well deserved!Wed, 14 Sep 2011 11:41:42 GMTBarbWhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxI cannot think of an award more deserved than this one.Congratulations, Jeff!And if you want to get together for drinks in Seattle, I am buying!Wed, 14 Sep 2011 10:03:48 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxI have learned many many things from his articles and posts (and still am).The man is a legend!*offers beer*Best regards,Wed, 14 Sep 2011 09:56:27 GMTcodebyohttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations to Jeff. He is an excellent choice as the recipient of this award.Wed, 14 Sep 2011 09:37:08 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff!Wed, 14 Sep 2011 09:32:35 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxJeff,Congratulations. Well deserved.Christian BahnsenWed, 14 Sep 2011 09:15:43 GMTChristian Bahnsenhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxJeff,You and the body of work, articles, code snippets and insight have been invaluable to me. You have inspired me to look for more than an answer, but for the best efficient solution.Thank you and congratulations on this well deserved award. You make being a dba/developer a better position and career.CheersTom :-)Wed, 14 Sep 2011 09:09:00 GMTTom_Sacramentohttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations!And indeed, thank you for all of your insights over the years.Wed, 14 Sep 2011 09:01:04 GMTHansBhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxJeff, let me add my hearty congratulations and "well deserved" to the clamorous accolades here.You bring a rare combination of deep knowledge, real-world pragmatism, clear writing, and pointed humor to just about everything of yours I've read. If anyone who will be [u]presenting[/u] Jeff with the award is reading this, may I suggest inclusion of (1) a hefty chunk of rebar, so that Jeff can break it in front of the assembled crowd and (2) a supply of pork chops. :w00t:Jeff, I'm a better DBA b/c of your articles and postings: thanks.RichWed, 14 Sep 2011 08:59:06 GMTrmechaberhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxAll bets are now opened.How many times will Jeff Write Thanks today?I'm betting 55 :-D.Wed, 14 Sep 2011 08:52:27 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxCongratulations Jeff. Well deserved.Wed, 14 Sep 2011 08:49:52 GMTsjimmohttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxThis is my favourite version:[code];WITH tenColumns AS ( SELECT 1 A, 2 B, 3 C, 4 D, 5 E, 6 F, 7 G, 8 H, 9 I, 10 J),tenRows AS ( SELECT n FROM tenColumns AS tC UNPIVOT ( n FOR col IN (A,B,C,D,E,F,G,H,I,J) ) AS p)SELECT 'country'FROM tenRows tCROSS JOIN tenRows t1[/code]:-PWed, 14 Sep 2011 08:30:02 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]Ninja's_RGR'us (9/14/2011)[/b][hr][quote][b]Gianluca Sartori (9/14/2011)[/b][hr]I guess now I'll have to write it 100 times on the blackboard...It worked with "definitely", so... why not?countrycountrycountrycountrycountry....:-D[/quote]Ah the good old day, when techers didn't know about copy / paste :-D.[/quote]Ah, the RBAR! Surely in honor of our honoree, you should have written something more like:SELECT TOP 100 'country' FROM master.sys.all_objects:-PWed, 14 Sep 2011 08:10:32 GMTsknoxhttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]sushila (9/14/2011)[/b][hr][quote]Ah the good old day, when techers didn't know about copy / paste :-D.[/quote]Tsk tsk Remi - in a hurry to type eh - it's good old days (plural) and even the techie teachers are not called techers!!! :hehe:[/quote]I saw it just as I was to hit post. guessed it was even funnier that way as we're teckies.:-DWed, 14 Sep 2011 08:10:22 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote]Ah the good old day, when techers didn't know about copy / paste :-D.[/quote]Tsk tsk Remi - in a hurry to type eh - it's good old days (plural) and even the techie teachers are not called techers!!! :hehe:Wed, 14 Sep 2011 08:06:38 GMTsushilahttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspx[quote][b]Gianluca Sartori (9/14/2011)[/b][hr]I guess now I'll have to write it 100 times on the blackboard...It worked with "definitely", so... why not?countrycountrycountrycountrycountry....:-D[/quote]Ah the good old day, when techers didn't know about copy / paste :-D.Wed, 14 Sep 2011 07:51:39 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1174628-1640-1.aspxI guess now I'll have to write it 100 times on the blackboard...It worked with "definitely", so... why not?countrycountrycountrycountrycountry....:-DWed, 14 Sep 2011 07:48:12 GMTspaghettidba