Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,301 through 42,315 (of 59,067 total)

RE: Twenty tips to write a good stored procedure

ta.bu.shi.da.yu (8/13/2009)
Well, I guess we'll agree to disagree.
Heh... I can do that.
But I can tell you, it's a royal pain.
Now there's something we can both agree on. 🙂
--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)

August 13, 2009 at 8:42 pm

#1039106
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/12/2009)
And you are right that 10% thought it was a great article and were put down
To be very clear, I never said that. What I said was...
I'd...
--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)

August 13, 2009 at 8:07 pm

#1039103
RE: SQLServerCentral Editorial Policy - Article Publication

Steve Jones - Editor (8/13/2009)
Instead I'd like to have the debate ensue, especially since I think the debate serves to better convince people of good (or bad) ideas than a...
--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)

August 13, 2009 at 7:51 pm

#1039097
RE: 'Add' to a character.

saivko (8/13/2009)
Whatever 'EIN' was (whether recreated or cleared) , it no longer exists as before. It is now a nvarchar calculated from the integer 'ID' column now.
Is...
--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)

August 13, 2009 at 7:13 pm

#1039093
RE: Self Join

Chuck Lucking (8/13/2009)
Thanks Jeff, I was hung up on having to do a self join with ranking to get the order I wanted. Just over engineering on my part....
--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)

August 13, 2009 at 6:36 pm

#1039077
RE: move the files

charipg (8/13/2009)
i want to copy through xp_cmdshell ?
what is the command.............
Charipg,
(Teach a man to fish...) There's a whole "language" for DOS/CMD and a full reference to boot. You...
--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)

August 13, 2009 at 6:27 pm

#1039074
RE: Are the posted questions getting worse?

Grant Fritchey (8/13/2009)
This is going to become a new badge of honor for people going for jobs or qualifying for MVP:
"And this article I wrote was plagiarized five times in...
--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)

August 13, 2009 at 6:07 pm

#1039069
RE: Twenty tips to write a good stored procedure

ta.bu.shi.da.yu (8/13/2009)
Jeff Moden (8/13/2009)
jswong05 (8/13/2009)
True portability is a myth.
True, basic compatibility is expected. Nothing is 100% compatible to another thing.:-P Why don't database vendors got together and make one...
--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)

August 13, 2009 at 6:00 pm

#1039068
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/13/2009)
Jeff Moden (8/12/2009)
If you want to reduce this conversation to a "game of egos ... rather than a genuine knowledge exchange" simply by saying so, then you're doing...
--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)

August 13, 2009 at 5:50 pm

#1039066
RE: SQL RECOMMENDATIONS

Great handle, too... My first recommendation is that you change that. I just won't help people with insults built into their chosen forum name.
--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)

August 13, 2009 at 11:53 am

#1038889
RE: Are the posted questions getting worse?

GilaMonster (8/13/2009)
Jeff Moden (8/12/2009)
Here's the link to the infringing article...
http://www.yourcomputerconsultant.com.au/support/default.asp?W276
I don't think that's Fog Creek (Joel Spolsky) themselves. They sell FogBugz software for customers to host on their own servers.
A...
--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)

August 13, 2009 at 11:50 am

#1038882
RE: Are the posted questions getting worse?

GilaMonster (8/13/2009)
Jeff Moden (8/12/2009)
I have discovered the second lowest form of life on the planet Earth. Check out the following URL... does the article look familiar to anyone?
http://balavardhanreddy.over-blog.com/article-29918397-6.html
La page...
--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)

August 13, 2009 at 11:47 am

#1038881
RE: 'Add' to a character.

saivko (8/13/2009)
Well, there is way too much to change on other tables, dts, access, website etc to make an int for every other table. I'm sort of stuck, needing...
--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)

August 13, 2009 at 11:25 am

#1038867
RE: Twenty tips to write a good stored procedure

jswong05 (8/13/2009)
True portability is a myth.
True, basic compatibility is expected. Nothing is 100% compatible to another thing.:-P Why don't database vendors got together and make one ANSI standard, 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)

August 13, 2009 at 11:18 am

#1038862
RE: Twenty tips to write a good stored procedure

jswong05 (8/13/2009)
ANSI SQL92 is the other code, instead. which will work for Oracle adn other SQL-92 DBs. Microsofter always uses tactics to push other people away, reader beware. :hehe:
ANSI 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)

August 13, 2009 at 9:34 am

#1038794

Viewing 15 posts - 42,301 through 42,315 (of 59,067 total)