Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,346 through 42,360 (of 59,102 total)

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
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

Viewing 15 posts - 42,346 through 42,360 (of 59,102 total)