Jeff Moden

Forum Replies Created

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

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
RE: Finding previous/next record based on criteria without using a cursor

mzak (4/9/2009)
Indeed.
Is there any reason I should use one join over another? I agree that the inner join is the better choice here because (like you said) I'm simply...
--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:17 pm

#975571
RE: The T-SQL Paradigm

Notice that the code window doubled up the word "ADD". That'll likely show up as an error if you copy the code.
--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 8:35 pm

#975541
RE: The T-SQL Paradigm

andrew gothard (4/9/2009)
Jeff Moden (4/4/2009)
And, you're absolutely correct... some simple additions such as TRUNC(Date) would make life a bit easier. On the other hand, I hope to never see...
--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 8:08 pm

#975537
RE: sp_dates add this proc to your code collection

BWAA-HAAA! And, just as soon as I posted that, my code in your quote became the old purple window. Like you said, don't beat me, but I'm using...
--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 7:14 pm

#975531

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