Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,316 through 42,330 (of 59,067 total)

RE: Twenty tips to write a good stored procedure

jpendergraft (8/13/2009)
What would the impact be if the select into was SELECT Top 0 * INTO FROM
to create the table struction and then do an insert into...
--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:30 am

#1038789
RE: 'Add' to a character.

saivko (8/13/2009)
Hmmm, can't validate that either. It seems string/text isn't allowed?
Correct... Sergiy's recommendation is based on the same thing I said... the ID column should be an INTEGER IDENTITY...
--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:26 am

#1038785
RE: help with pulling values for multiple dates...

quayludious (8/13/2009)
any thoughts on it or should I just leave well enough alone?
Agh... sorry... this got lost in about a zillion other emails. I'll try to get back to...
--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:50 am

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

GilaMonster (8/10/2009)
Jeff Moden (8/10/2009)
[font="Arial Black"]Absolutely not true. Please, folks... stop perpetuating this myth.[/font] That's a left over wives tale for the original version of 6.5. Don't take...
--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 12, 2009 at 11:23 pm

#1038465
RE: Are the posted questions getting worse?

Wonders never cease... FogBugz also published my article on their site without my permission. Admittedly, they gave both SSC and myself credit for the article, but they did not...
--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 12, 2009 at 10:46 pm

#1038450
RE: Are the posted questions getting worse?

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
I've contacted the legal department...
--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 12, 2009 at 10:26 pm

#1038446
RE: vbscripts to know the version sql server

I agree with Lowell... unless you're doing this just for fun or, maybe, you're trying to build your own version of it for profit, purchasing SQL Recon will probably be...
--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 12, 2009 at 7:30 pm

#1038408
RE: WORD UP!

Thanks for the help, Joe. I appreciate the time.
The answers would be "no, nothing like that going on" to 1, "did both before and yes, same problem" to 3,...
--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 12, 2009 at 7:08 pm

#1038405
RE: Are the posted questions getting worse?

tosscrosby (8/12/2009)
jcrawf02 (8/12/2009)
tosscrosby (8/12/2009)
OK, the avatar changes have started to freak me out a bit (especially http://www.sqlservercentral.com/Forums/UserInfo553377.aspx)
Does anyone really look like that without some type of "cropping" occurring? I'm not...
--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 12, 2009 at 7:02 pm

#1038403
RE: SQLServerCentral Editorial Policy - Article Publication

RBarryYoung (8/12/2009)
Steve:
I like the idea of volunteers reviewing the submissions, but I share some of the concerns others have mentioned also. But as I see it, ultimately,...
--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 12, 2009 at 6:56 pm

#1038401
RE: SQLServerCentral Editorial Policy - Article Publication

Lynn Pettis (8/12/2009)
Steve Jones - Editor (8/12/2009)
Lynn Pettis (8/12/2009)
Does that include the 2 I sent for you to republish on SSC, or had you already taken care of those? 😉
Nope,...
--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 12, 2009 at 6:01 pm

#1038397
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/12/2009)
But the author did not spend hours writing an article that turned out to be very poor for fun.
Correct... the author did not spend hours writing that article...
--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 12, 2009 at 5:48 pm

#1038394
RE: Are the posted questions getting worse?

jcrawf02 (8/12/2009)
Bob Hovious (8/12/2009)
With the repeated reference to Starship Troopers, I find myself muttering under my breath as I go over some code....
"Bugs, Mr. Rico. Millions of 'em....
--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 12, 2009 at 12:11 pm

#1038194
RE: SQLServerCentral Editorial Policy - Article Publication

Yes... I'm talking about some of the folks that posted to that thread.
--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 12, 2009 at 12:03 pm

#1038188
RE: WORD UP!

No problem... thanks for taking the time to repost. It's another avenue I can check. Thanks.
--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 12, 2009 at 12:01 pm

#1038186

Viewing 15 posts - 42,316 through 42,330 (of 59,067 total)