Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,366 through 52,380 (of 59,091 total)

RE: Ways to deal with NULLS.

Heh... the correct answer is that no one has yet defined what a NULL in the age column is actually supposed to represent. Therefore, the possibilities are endless until...
--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)

February 25, 2008 at 11:54 am

#781691
RE: Flat files without delimiters

karthi (2/25/2008)
Hi,
I have a flat file without delimiters. The format is like
L10123444 221
but Col1 = L;col2=1;col3=0123444 etc...
how to import this kind of flat file
Thanks in advance
All of the methods...
--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)

February 25, 2008 at 10:19 am

#781656
RE: looking for opinion on how to handle a project...

I'm with Jack on this one, Chris... a rewrite should be an opportunity to do things much better. I'd look at the code you're getting to rewrite and bust...
--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)

February 25, 2008 at 10:05 am

#781645
RE: Ways to deal with NULLS.

How confident are you that you can formulate a query to pprecisely answer a particular question?
How would you know if it was "wrong"?
It goes back to exactly 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)

February 25, 2008 at 9:19 am

#781617
RE: XML/CSV Data Source

Man, I agree with that... personal choice on such things is rare indeed. If you do get to make the choice, despite what I or anyone else says, choose...
--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)

February 25, 2008 at 8:00 am

#781556
RE: BEGIN and END in stored procedure

Well I'll be darned... you remembered 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)

February 25, 2008 at 7:54 am

#781553
RE: Ways to deal with NULLS.

Yeaup... I agree... and that's what I meant. You must define what NULL means as part of the design of the table and you must understand what it means...
--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)

February 25, 2008 at 7:42 am

#781548
RE: XML/CSV Data Source

Although XML would have a grand draw here, I loath it because of the duplicated data in the form of tags. A 1 mega-byte flat file can take 8...
--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)

February 25, 2008 at 6:53 am

#781526
RE: Bit Data Types

No... I wouldn't use a CHAR(1) for this... if there are predetermined numeric codes, it's by design... perhaps a requirement for a different app. Having to translate meanings between...
--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)

February 25, 2008 at 6:38 am

#781521
RE: BEGIN and END in stored procedure

I know of no advantage... I did a test once on a 10 million row table where it seemed to run a couple ms faster without BEGIN/END... but nothing real...
--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)

February 25, 2008 at 6:30 am

#781517
RE: Export Data to Excel

Yeaup... I agree... BCP will work, as well.
Big problem with both methods (xp_CmdShell/BCP and sp_OA*) is that they both require some extraordinary privs (SA) to execute. That's not necessarily...
--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)

February 25, 2008 at 6:17 am

#781514
RE: Ways to deal with NULLS.

Andrew (2/25/2008)
Jeff - In which ways can you deal with the problems caused by NULL then - for example the fact that TRUE AND NULL = NULL or 6 *...
--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)

February 25, 2008 at 6:07 am

#781511
RE: Ways to deal with NULLS.

None of your questions in the poll pertain to the actual use of nulls. Nulls simply mean "unknown". They are a powerful tool that are frequently misunderstood.
--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)

February 24, 2008 at 9:59 pm

#781466
RE: Thoughts on Andy Warren's Article 'Management'

So... you know what to do, Loner... take control...
--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)

February 24, 2008 at 9:26 pm

#781462
RE: Thoughts on Andy Warren's Article 'Management'

Loner (2/24/2008)
I feel liked I am doomed...
And, that is your ONLY problem... you must use your (if I may) God-gifted intelligence to overcome such problems and realize that you are...
--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)

February 24, 2008 at 9:23 am

#781427

Viewing 15 posts - 52,366 through 52,380 (of 59,091 total)