Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,506 through 32,520 (of 59,099 total)

RE: Are the posted questions getting worse?

Ninja's_RGR'us (9/21/2011)
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Steve Jones - SSC Editor (9/21/2011)
Just a note, in case you didn't see it, Jeff's interview is up: http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75986/
Forget that crap, this is even better!
http://www.sqlservercentral.com/Forums/FindPost1179084.aspx
CELKO...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 22, 2011 at 9:35 am

#1385252
RE: Query optimizing 2

{Edit} Post withdrawn... still testing and posted too early.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 22, 2011 at 7:24 am

#1385135
RE: Nested While loop

Michael A. (9/21/2011)
The issue is that the current WHILE logic will stop once the values within one array are exhausted.
Hmmm... been thinking about this... Sean's code does a great job...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 22, 2011 at 7:21 am

#1385134
RE: The 2011 SQLServerCentral Party at the PASS Summit

I couldn't say it before but I'll definitely be there. Thank all of you for making it possible!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 9:25 pm

#1384930
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Harveysburger (9/21/2011)
Thumbs up from Curaçao
Thank you and good to "see" you again. Is Roy going to let you go to PASS with him this year?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 9:18 pm

#1384929
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

ken.trock (9/21/2011)
Jeff, congratulations on the award. I know everytime I need a solution to a database programming problem my well trained programmer brain wants to construct a loop. Then I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 9:16 pm

#1384928
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Roy Ernest (9/21/2011)
Evil Kraig F (9/21/2011)
*claps* Rock on ya old whitebeard! Us younguns are still learnin' every day from ya! 😀
You a youngun? :hehe:
Great job Jeff.....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 9:06 pm

#1384927
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Evil Kraig F (9/21/2011)
*claps* Rock on ya old whitebeard! Us younguns are still learnin' every day from ya! 😀
Heh... I'm really only 23! Guess I'm going...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 9:03 pm

#1384925
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Chris Harshman (9/21/2011)
I'd just like to say how glad I am that Jeff is a part of the SQL Server community, and say thanks for all I've learned from his...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:48 pm

#1384923
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Jim Murphy (9/21/2011)
Congratulations Jeff! Well deserved. Really.
I look forward to meeting you at The Summit in a few weeks!
I especially appreciate your spirit of giving. Let me...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:45 pm

#1384922
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

sql_lock (9/21/2011)
Simply, well deserved!!!
Thank you for the feedback. I aim to please. I sometimes miss, but I'm always aiming. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:31 pm

#1384920
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

opc.three (9/21/2011)
Congratulations Jeff, and Thank You for all you do 🙂
Thanks, Orlando. I've not forgotten the pair of articles you and I want to write together. It's going...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:25 pm

#1384918
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

sharath.chalamgari (9/21/2011)
Congrats Jeff, this will be really inspirational for other sql folks.
Thanks, Sharath. I really do hope this helps inspire others especially when it comes to sharing knowledge. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:21 pm

#1384917
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Anipaul (9/20/2011)
Great Jeff Great Talk!!! Thanks for all the help you provided to all of us!!!
We should also thank Rich Bay and your boss 🙂 for the "accident", otherwise...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 8:08 pm

#1384916
RE: UPDATE without listing all columns?

boeledi (9/21/2011)
Hi,
I have 2 tables with the very same LONG structure (table_1 and table_2).
I was wondering if it would be possible to update table_1 with the content of table_2 without...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 21, 2011 at 3:47 pm

#1384869

Viewing 15 posts - 32,506 through 32,520 (of 59,099 total)