Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,781 through 51,795 (of 59,098 total)

RE: Writing the code for a stored procedure

Bob Fazio (3/15/2008)
Boy was that cough medicine strong :sick:
I never thought of a computer as heavy machinery 😉
😀 Man, thanks for having a good sense of humor. I've...
--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)

March 15, 2008 at 9:59 am

#790017
RE: How do I BULK INSERT only one or some of the fields in the row?

mukundbtech (3/13/2008)
Thank u .. and like to know is there any other option other than using a format file .. if so help me
Rethinking this, DTS would probably be 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)

March 15, 2008 at 12:45 am

#789970
RE: How do I BULK INSERT only one or some of the fields in the row?

Greg Snidow (3/14/2008)
Jeff, I have found that information helpful to a format file newbie is hard to come by. Maybe you know of an article that explains it 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)

March 15, 2008 at 12:43 am

#789969
RE: How to fill the record for missing month

halifaxdal (3/14/2008)
Thank you Jeff.
You bet... thank you for the feedback.
--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)

March 15, 2008 at 12:36 am

#789968
RE: Linking to the Previous Row

Before you use any of those that have a self join or correlated subquery that use the ">=" or "<=" or any other inequality method to generate row numbers, 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)

March 15, 2008 at 12:31 am

#789967
RE: Writing the code for a stored procedure

Bob Fazio (3/14/2008)
It is currently against the law to use the SSN as a PK (I went through much pain to change several databases). Ok, the law states that...
--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)

March 15, 2008 at 12:11 am

#789966
RE: Writing the code for a stored procedure

Bob Fazio (3/14/2008)
Pat Reiter (3/14/2008)
Examples use CHAR(9), but compare to string of format '###-##-####' . Are the dashes not part of the string?
The example was wrong. It should...
--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)

March 15, 2008 at 12:02 am

#789965
RE: More RBAR and "Tuning" UPDATEs

p.s. All the times, scan, and read counts for my previous post were on SQL Server 2k... the optimizer in 2k5 was a little more kind to 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)

March 14, 2008 at 11:55 pm

#789964
RE: More RBAR and "Tuning" UPDATEs

Hey, before I get started on this, "thank you" to all of the folks that took time to provide
some feedback, whether it was pro or con. That's what...
--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)

March 14, 2008 at 11:44 pm

#789963
RE: How to fill the record for missing month

Heh... although I'd like to take credit for it, I think that was when they were having date problems on the forum. 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)

March 14, 2008 at 5:55 pm

#789933
RE: Selecting a range from mixed alpha-numeric column

Forget the cursors, forget the LIKEs... and remember that ISNUMERIC treats "-", and a whole bunch of other characters as valid numeric characters. NEVER use ISNUMBER as IsAllDigits because...
--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)

March 14, 2008 at 3:50 pm

#789925
RE: Can a temporary table created with an execute statement survive that statement?

shamas saeed (3/14/2008)
Yes You can do with as all above says or use ## to use it in procedure
Global temp tables are a bad idea... if more than one instance...
--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)

March 14, 2008 at 12:53 pm

#789846
RE: I got burned today at a SQL Server Interview!

John Rowan (3/14/2008)
I just wanted to thank you all for your military service.
Awesome, John. Thank you, Sir!
--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)

March 14, 2008 at 9:51 am

#789736
RE: I got burned today at a SQL Server Interview!

Chrissy (3/14/2008)
Hi guys,
I am very much a newbie, and I just wanted to say this forum has actually given me confidence to start training as a SQL DBA in my...
--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)

March 14, 2008 at 9:50 am

#789734
RE: More RBAR and "Tuning" UPDATEs

Anders Bendix Nielsen (3/14/2008)
That is simply one of the best articles on RBAR I have ever seen!
Excellent!! 🙂
Thanks for the great feedback, Anders.
--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)

March 14, 2008 at 8:10 am

#789647

Viewing 15 posts - 51,781 through 51,795 (of 59,098 total)