Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,721 through 42,735 (of 59,067 total)

RE: differiniate quotes as data vs quotes as column identifier

Ah... sorry, Ghanta... I've got just one more question...
Do you know how to BULK INSERT a file into a single column table or 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)

July 25, 2009 at 11:17 pm

#1030243
RE: differiniate quotes as data vs quotes as column identifier

Ghanta (7/25/2009)
Jeff Moden (7/25/2009)
Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field -...
--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)

July 25, 2009 at 11:11 pm

#1030242
RE: differiniate quotes as data vs quotes as column identifier

Jeff Moden (7/25/2009)
Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field - always...
--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)

July 25, 2009 at 11:07 pm

#1030241
RE: differiniate quotes as data vs quotes as column identifier

BobMcC (2/18/2008)
I need to import (using DTS) some comma delimited text files into sql server 2000.
I have discovered that the quotation mark is getting dual use. Not only is some...
--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)

July 25, 2009 at 11:00 pm

#1030239
RE: differiniate quotes as data vs quotes as column identifier

Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field - always quoted
3rd field...
--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)

July 25, 2009 at 10:49 pm

#1030237
RE: differiniate quotes as data vs quotes as column identifier

Ok.... a couple of questions...
First, some data from your post...
[font="Courier New"]6053339541,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"
__________ ________________________________ __ ________________ ____________
6053339542,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"
__________ _____________________________________ __ ________________ ____________
6053448211,"L'ARGENTIERE BAT A, 637 BD TAVERNIERE",02,this is a sample,"tiger, scott"[/font]
1. Except for the first column (ID), the first 2 rows above appear to be duplicates. Should one...
--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)

July 25, 2009 at 10:46 pm

#1030236
RE: Are the posted questions getting worse?

Paul White (7/25/2009)
Talking of number plates, a guy who used to work at my place had SQLDBA as his plate.
I quite fancy this one or this one
Anyone got any clever...
--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)

July 25, 2009 at 10:33 pm

#1030235
RE: Are the posted questions getting worse?

Jack Corbett (7/25/2009)
For Jeff, PRKCHP
or
BACKUP
or
RSTORE
Heh... I prefer ...
NO RBAR
or
RTFM
or
MILTP41
or
DIEANSI
or my favorite...
TALLYTBL
--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)

July 25, 2009 at 10:20 pm

#1030234
RE: Index scan hint

Paul White (7/25/2009)
I realize my point was slightly off-topic, but I couldn't resist the opportunity to discuss some of the subtleties.
Speaking of "off topic"... that's part of the reason...
--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)

July 25, 2009 at 9:45 pm

#1030231
RE: Existance Check - Performance

matt stockham (7/24/2009)
Jeff Moden (7/24/2009)
happycat59 (7/23/2009)
Using COUNT(1) requires SQL Server to return all records that meet the criteria.
Ummmm.... nope... it doesn't... it stops searching as soon as it finds one...
--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)

July 25, 2009 at 9:40 pm

#1030229
RE: many small tables vs. one large table??

Paul White (7/25/2009)
Splitting the data into 12 tables and using a partitioned view (available in all editions) will almost certainly perform better.
Steve Jones - Editor (7/25/2009)
I'm just wondering if 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)

July 25, 2009 at 9:35 pm

#1030228
RE: Map IP Address to a Geographical Location

Heh... sorry Peter... Thought you were trying to flatten the trajectory of a pork chop for some reason. 😀 I'm a bit touchy because I'm trying to quit smoking,...
--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)

July 25, 2009 at 9:27 pm

#1030227
RE: differiniate quotes as data vs quotes as column identifier

Ghanta...
I believe I have your solution. I'll post it both here and on SQL Team (your other post, I believe) but I wonder if you'd do me 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)

July 25, 2009 at 9:11 pm

#1030224
RE: Map IP Address to a Geographical Location

Peso (7/25/2009)
Or see this topic from 2006...
Refreshers are never a bad thing. 😉
--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)

July 25, 2009 at 12:36 pm

#1030196
RE: Index scan hint

Paul White (7/24/2009)
Lynn Pettis (7/23/2009)
Jeff Moden (7/22/2009)
Lynn Pettis (7/22/2009)
Why? Seeks are faster than scans.
Heh... because "A developer must not guess... a developer must KNOW." 😉 It'll be 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)

July 24, 2009 at 5:00 pm

#1030090

Viewing 15 posts - 42,721 through 42,735 (of 59,067 total)