Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,896 through 53,910 (of 59,072 total)

RE: Database Design Question

What? Oh? OH? OOOOOHHHHH!!! BWAAAA-HAAAAAA-HAAAAA! WHOOOOO-IIIIEEEEEE! SNNOORRRTTT! Now, THAT's funny, David!!!! OMIGOD!!! I CAN'T QUIT LAUGHING!!!! TOO FUNNY,...
--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)

November 27, 2007 at 5:32 pm

#754792
RE: Database design

Karthik,
No... that's what a lot of folks do and it's not database design. For starters, each table should have a primary key (as well as having a clustered index...
--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)

November 27, 2007 at 5:24 pm

#754791
RE: What is the difference between Programmer and Good Programmer ?

Actually... I like VSS. No, it won't merge your code for you or handle branches, etc, etc. But guess what? I'm not a Java programmer! 😉
If people...
--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)

November 27, 2007 at 4:49 pm

#754786
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Thanks for the feedback, John! Yeah, same thing here... sometimes the language barrier is a bit difficult to get through, but a well formed Create Table statement cut's through...
--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)

November 27, 2007 at 4:42 pm

#754784
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Jason Selburg (11/27/2007)
Lynn Pettis (11/27/2007)
Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse to water...
😎
....You're...
--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)

November 27, 2007 at 11:27 am

#754688
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Steve Jones - Editor (11/27/2007)
We could put a posting guide, though I'm not sure many people will read it.
I think I'll re-run this once a month or so 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)

November 27, 2007 at 11:25 am

#754686
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Wow! So many great comments and ideas... I can't keep up with all the posts! Thank you all for taking the time out of your busy day 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)

November 27, 2007 at 11:19 am

#754685
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Opus (11/27/2007)
As someone who generally posts more questions than answers, I thought this was a great article. Any way to make this required reading before someone creates their first...
--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)

November 27, 2007 at 11:05 am

#754674
RE: Forum Etiquette: How to post data/code on a forum to get the best help

David Bird (11/27/2007)
I liked your SQL example. Inserts into tables with Identity columns can be challenging. So besides providing excellent advice on submitting forum questions you provide a flexible script...
--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)

November 27, 2007 at 10:57 am

#754668
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Jason Selburg (11/27/2007)
My fingers are crossed that people actually read this article!
One can only hope, ol' friend. And, thanks for the compliment 🙂
--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)

November 27, 2007 at 10:54 am

#754666
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Heh... I guess the "bad code" example was so bad, that the Code window couldn't handle it... so, here it is... sans code window...
select v.* from #mytable v, ( select...
--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)

November 27, 2007 at 10:52 am

#754664
RE: Forum Etiquette: How to post data/code on a forum to get the best help

rudy komacsar (11/27/2007)
Jeff, the article is excellent ! (I have to look at the site to cast a vote - 5 stars in my book).
Steve, maybe we can put 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)

November 27, 2007 at 10:37 am

#754657
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Kenneth Fisher (11/27/2007)
You know all of this remind me of one of my favorite help requests I had when I was a lead developer years ago.
"Its broken"
Literally .. that was...
--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)

November 27, 2007 at 10:36 am

#754656
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Having the test data in a ready to use format is great, but even if they provide it in a tabular format, it is better than nothing
Hi Lynn,
Thanks for 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)

November 27, 2007 at 9:42 am

#754637
RE: Forum Etiquette: How to post data/code on a forum to get the best help

-=JLK=- (11/27/2007)
Nice article Jeff. Great "how to" without being to pushy. Nothing puts me off answering a post like having to much "up front" work so I 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)

November 27, 2007 at 9:38 am

#754633

Viewing 15 posts - 53,896 through 53,910 (of 59,072 total)