Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,066 through 40,080 (of 59,072 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (1/27/2010)
I need a couple of volunteers if any are willing and have some spare time.
I am wrapping up an article and would like somebody else to review it if...
--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)

January 28, 2010 at 6:32 pm

#1110407
RE: Are the posted questions getting worse?

CirquedeSQLeil (1/27/2010)
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That 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)

January 28, 2010 at 6:30 pm

#1110405
RE: Are the posted questions getting worse?

Alvin Ramard (1/27/2010)
Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should be required reading...
--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)

January 27, 2010 at 4:36 pm

#1109662
RE: Row to Column Conversion

Thanks for the compliment, Nabha. :blush:
--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)

January 27, 2010 at 3:28 pm

#1109632
RE: Time - Need to convert varchar to time

tan110 (1/27/2010)
Had to loop through all the records.
Heh... GAHHH!!!! 😉
--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)

January 27, 2010 at 3:23 pm

#1109629
RE: Alternate of Row_Number() in SQL 2000

If the machine you do this on has more than one processor, you really need to add OPTION(MAXDOP 1) to the update query. It's also been determined that 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)

January 27, 2010 at 3:14 pm

#1109619
RE: Time - Adding minutes and seconds

Ah... sorry Wayne... didn't see your post which is the same as what I just suggested.
--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)

January 27, 2010 at 1:03 pm

#1109546
RE: Time - Adding minutes and seconds

I know the problem has already been solved but DATEADD isn't the solution you need here because that requires that you do split the data into its various time components....
--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)

January 27, 2010 at 1:00 pm

#1109543
RE: Trouble importing a large flat file

As a sidebar, this is where BCP and BULK INSERT really shine... you can tell both to automatically sequester bad rows while still processing the good ones with just 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)

January 27, 2010 at 12:54 pm

#1109536
RE: Trouble importing a large flat file

Simple... setup a BULK INSERT in T-SQL to read whole lines of data from the file into a scratchpad table. Then do something like the following to find extra...
--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)

January 27, 2010 at 12:51 pm

#1109532
RE: Ways to run large script files

No... heh... I've never seen a single script so large. As a side bar, you've just got to ask how someone tested it if it can be executed as...
--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)

January 27, 2010 at 11:06 am

#1109454
RE: File Loading

It's been a while since I've used 7-ZIP but I beleive one of the parameters available is an "unzip all from here down" type of parameter. 7-Zip comes 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)

January 27, 2010 at 11:04 am

#1109452
RE: A Dearth of Comments

Thanks for the feedback, Steve.
--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)

January 27, 2010 at 10:55 am

#1109440
RE: bcp

Can we see the BCP command, please, John? Be sure to remember to not include your server password. Thanks.
--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)

January 26, 2010 at 11:10 pm

#1109111
RE: Ways to run large script files

Shifting gears, I don't believe the OP was talking about data files, though... It sounds like the OP has a T-SQL script that's 200MB long and is trying to execute...
--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)

January 26, 2010 at 11:06 pm

#1109110

Viewing 15 posts - 40,066 through 40,080 (of 59,072 total)