Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,806 through 35,820 (of 59,099 total)

RE: BCP without xp_cmdShell

Pam Brisjar (12/3/2010)
You should also consider running it through an SSIS package.
+1
--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)

December 3, 2010 at 10:59 pm

#1258726
RE: Parse text in a string

Black Mamba (12/3/2010)
Its Perfect.. 🙂
True enough. Wayne does a great job on these types of things. The real question here is, have you studied the code to know...
--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)

December 3, 2010 at 10:53 pm

#1258725
RE: Huge tables with no appropriate column for creating clustered index !

PaulB-TheOneAndOnly (12/3/2010)
May I spice this one?
Subjet of this thread is...
Sachin Vaidya (11/23/2010)
Huge tables with no appropriate column for creating clustered index!
...and I say "so what?" 😀
There is the common...
--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)

December 3, 2010 at 10:48 pm

#1258724
RE: Create same password for 150 users with script.

george sibbald (12/3/2010)
ok, I'll ask - why do you want all your users (well, three quarters) to have the same password?
I'm right there with George on this one. There's...
--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)

December 3, 2010 at 10:38 pm

#1258722
RE: Are the posted questions getting worse?

GilaMonster (12/2/2010)
Tom.Thomson (12/1/2010)
Greg Edwards-268690 (12/1/2010)
GilaMonster (12/1/2010)
You know there's a problem when...
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent...
--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)

December 3, 2010 at 8:58 pm

#1258714
RE: Are the posted questions getting worse?

Roy Ernest (12/3/2010)
I have tried my level best to help this OP in the replication section. I went through different scenario, but no luck. Could someone take a look at...
--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)

December 3, 2010 at 8:56 pm

#1258713
RE: Flat File not outputting Row Delimiters

Heh... now that I've read the rest of the posts, it looks like I wasn't too far off. Still, BCP would knock the socks off this "ragged right" problem...
--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)

December 3, 2010 at 8:48 pm

#1258711
RE: Flat File not outputting Row Delimiters

Craig Farrell (12/3/2010)
SSIS 2k5. Simple structure. 2 Connections, one is a source of OLEDB (source data, SQL Database), second is Destination of Fixed Width Flatfile. It's for...
--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)

December 3, 2010 at 8:44 pm

#1258710
RE: get next number when gaps in records

jane47 (12/2/2010)
I need to use the numbers because my customer initially blocks out a range of numbers, then adds records using these blocked numbers, or the next available number in...
--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)

December 3, 2010 at 8:34 pm

#1258708
RE: SQL Function to Split Comma Separated Values and Insert into Table

WayneS (12/1/2010)
chris-860960 (11/30/2010)
Just switched to WayneS' non-RBAR function. Now that's FAST!
It's not "my" function - it comes from Jeff Moden. It's just what is in use around here, with...
--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)

December 3, 2010 at 8:28 pm

#1258707
RE: dropping a column doesnt create space at all..?

sqldba_icon (12/2/2010)
Suresh B. (12/1/2010)
Try
DBCC CLEANTABLEHope this helps you.
Thanks Suresh. Theoritically it seems like it will work. I ran DBCC CLEANTABLE (Test_db,"dbo.Mytable") and took 7 hours and is still running. Mytable...
--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)

December 2, 2010 at 11:00 pm

#1258218
RE: get next number when gaps in records

jane47 (12/2/2010)
hi
I have a table that contains records that identified by a number. When a new record is inserted, I need to generate the next number in sequence. (was going...
--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)

December 2, 2010 at 10:55 pm

#1258217
RE: Set Up And Schedule a Server Side Trace

Good stuff as always, Grant! Thanks for taking the time to write articles like this. This one should be in every DBA's quick reference guide. 🙂
--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)

December 2, 2010 at 10:43 pm

#1258213
RE: temp table usage

Ninja's_RGR'us (12/1/2010)
pspeagle (12/1/2010)
I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire duration of...
--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)

December 2, 2010 at 10:22 pm

#1258205
RE: Export with Headers

Grant Fritchey (12/2/2010)
For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.
Steve asked for "using bcp, SQLCMD", but...
--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)

December 2, 2010 at 10:16 pm

#1258202

Viewing 15 posts - 35,806 through 35,820 (of 59,099 total)