Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,931 through 48,945 (of 59,102 total)

RE: OpenRowset Bulk Import Flat files with header & Footer

The header must have exactly the same delimiters as the 2nd row which must match all the other rows, or BCP will give you that error and the 2nd row...
--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 5, 2008 at 10:13 pm

#853613
RE: bcp asking for Password even with -T option

Amit Chaudhary (8/5/2008)
Hello,
I think I am asking this question in the right forum.
THe configuration on my server is TCPIP Enabled, Named Pipes Enabled. The order of SQL Native CLient Protocols...
--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 5, 2008 at 10:10 pm

#853610
RE: Loop insertion

How many rows are you talking about copying? I'm thinking that you don't actually need the WHILE loop because of the explicit transaction you've declared. Use set based...
--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 5, 2008 at 10:04 pm

#853608
RE: Partitioned Table Performance

Gareth (7/31/2008)
I'm a complete newbie to table partitioning, so this question may be silly.
I was asked to investigate the possibility of table partitioning by a developer.
I used a 7 gig...
--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 5, 2008 at 10:00 pm

#853605
RE: Using a variable column name...

And, if you don't mind, tell us why it has to be a dynamic column name. 😉
--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 5, 2008 at 9:57 pm

#853604
RE: Select from 25 million Rows

Index... maybe a partitioned table, to boot.
--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 5, 2008 at 9:54 pm

#853603
RE: TRIM functions do not work

Or... you can beat the crud out of a string anyway you like... 🙂 CREATE FUNCTION dbo.udf_Extract
/*******************************************************************************
Purpose:
========
Removes unwanted characters from a string.
Notes:
======
Possible inclusive values...
--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 5, 2008 at 8:41 pm

#853593
RE: How to run a query to bring all the fields from each table

Atif Sheikh (8/5/2008)
Hi Jeff..
I executed your script and, surprisingly, got an error. One of my databases was in the recovering status and raised error on that database.
So I altered your...
--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 5, 2008 at 8:12 pm

#853590
RE: How to run a query to bring all the fields from each table

Heh... couldn't resist, Barry.
Hey! Are you going to PASS this year? Sure would like to do some 12 oz. curls with ya someday. Bring your helmet so...
--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 5, 2008 at 8:10 pm

#853589
RE: Just For Fun: An Impossible Delete

Very cool, Jacob! Thanks for taking the time to test it and other methods, as well! 🙂
I wish I could take the credit for the 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 5, 2008 at 8:06 pm

#853588
RE: Money vs. Decimal Data type

meichner (8/5/2008)
Thanks to both Jeff and Jacob for the help. Based on your posts I will use decimal instead of money. I was wondering, since I am only working...
--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 5, 2008 at 7:03 pm

#853576
RE: Just For Fun: An Impossible Delete

Jacob Luebbers (8/5/2008)
Jeff Moden (8/5/2008)
...For example, the fastest "missing sequence" code I've ever seen uses a couple of correlated sub-queries which is a form of RBAR... but the constraints it...
--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 5, 2008 at 6:46 pm

#853573
RE: Deleting 400K rows

CrazyMan (8/5/2008)
There are 10 indices out of which one is clustered, no trigger, does this affect deleting???
The clustered one is the easy one for deletes... the other 9 are add...
--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 5, 2008 at 6:16 pm

#853568
RE: How to run a query to bring all the fields from each table

rbarryyoung (8/5/2008)
Jack Corbett (8/5/2008)
I don't know, based on your time in the field from your recently posted article, I feel like I need to show you proper respect and call...
--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 5, 2008 at 6:10 pm

#853564
RE: How to run a query to bring all the fields from each table

Jack Corbett (8/5/2008)
Also mine does take advantage of a undocumented (by MS) procedure that could change or disappear so using sys.databases and the dynamic SQL is probably better.
Heck... I wouldn't...
--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 5, 2008 at 5:50 pm

#853561

Viewing 15 posts - 48,931 through 48,945 (of 59,102 total)