Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,266 through 44,280 (of 59,101 total)

RE: Are the posted questions getting worse?

Well... I did it. Thank goodness they extended the deadline of PASS 2009 Session Abstracts. I'll be there one way or another this year.
I saw that...
--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)

April 11, 2009 at 11:02 am

#976128
RE: T-SQL 2005 Help

GilaMonster (4/11/2009)
Shane Redding (4/11/2009)
In regards to the below, perhaps you should go work for the microsoft sql server team as GOTO is not uncommon in TSQL. 🙂
Just because the...
--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)

April 11, 2009 at 10:57 am

#976127
RE: Are the posted questions getting worse?

GilaMonster (4/11/2009)
Bob Hovious (4/11/2009)
Okay... how many people here advocate the use of GOTO statements in T-SQL?
I do, solely for error handling in SQL 2000. Since there isn't a TRY-CATCH construct...
--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)

April 11, 2009 at 10:52 am

#976123
RE: steve's dataphore

steve dassin (4/10/2009)
Jeff Moden (4/10/2009)
steve dassin (4/10/2009)
Do you realize that for over thirty years the relationship between the sqland and relationaland can be categorized by one word - 'Failure'.
Yep......
--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)

April 11, 2009 at 1:46 am

#976015
RE: Are the posted questions getting worse?

Lynn Pettis (4/10/2009)
edit: this one
Oh... that one. It'll probably turn out that they don't have the user login setup on the other machine(s) or, if it is, they...
--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)

April 10, 2009 at 7:44 pm

#976005
RE: Are the posted questions getting worse?

GilaMonster (4/10/2009)
Jeff Moden (4/10/2009)
If that site has truly cribbed the exams, then the MS Certs have become truly useless for evaluating a potential employee's skills based on the cert...
--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)

April 10, 2009 at 7:39 pm

#976004
RE: steve's dataphore

steve dassin (4/10/2009)
Do you realize that for over thirty years the relationship between the sqland and relationaland can be categorized by one word - 'Failure'.
Yep... you've told us many...
--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)

April 10, 2009 at 6:59 pm

#975998
RE: steve's dataphore

steve dassin (4/10/2009)[hrThe butcher, the baker and the candlestick maker! You telling me Grimm's Fairy Tales is R rated. I was just being playful. Hey guys lighten up. Think split...
--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)

April 10, 2009 at 6:48 pm

#975996
RE: Are the posted questions getting worse?

Lynn Pettis (4/9/2009)
Any help on that thread would be welcome. Based on further information from the OP, I'm thinking something written using SMO may be a better option than...
--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)

April 10, 2009 at 2:30 pm

#975962
RE: Are the posted questions getting worse?

GilaMonster (4/8/2009)
Jeff Moden (4/7/2009)
Actually... I don't believe you have to be an MVP to nominate someone. I think anyone can do it. The more, the merrier.
Anyone can,...
--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)

April 10, 2009 at 2:29 pm

#975961
RE: Are the posted questions getting worse?

GilaMonster (4/10/2009)
Jeff Moden (4/9/2009)
I believe you need to ping back and say it was an error. Read the last post on that link very carefully.
I'll take that 'apology' with...
--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)

April 10, 2009 at 2:22 pm

#975959
RE: Are the posted questions getting worse?

Chris Morris (4/10/2009)
Steve Jones - Editor (4/8/2009)
I'm not sure Jeff will get that one done, so someone else feel free to tackle it. He's agreed to start a nice T-SQL...
--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)

April 10, 2009 at 2:18 pm

#975957
RE: steve's dataphore

steve dassin (4/10/2009)
Jeff Moden (4/10/2009)
steve dassin (4/10/2009)
Just a note to say I'll be addressing some interesting responses from the discontinued thread:
T-Sql rant
http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx
Some of the responses were thoughtful and interesting, especially...
--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)

April 10, 2009 at 2:10 pm

#975956
RE: steve's dataphore

steve dassin (4/10/2009)
Just a note to say I'll be addressing some interesting responses from the discontinued thread:
T-Sql rant
http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx
Some of the responses were thoughtful and interesting, especially from Matt "The Dragon"...
--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)

April 10, 2009 at 6:17 am

#975698
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/9/2009)
FYI, I also pinged MS on our boasting user.
I believe you need to ping back and say it was an error. Read the last post...
--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)

April 9, 2009 at 11:22 pm

#975573

Viewing 15 posts - 44,266 through 44,280 (of 59,101 total)