Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,561 through 37,575 (of 59,098 total)

RE: Math function question

Joe Celko (7/22/2010)
brian.cook (7/22/2010)
Thanks, I knew it would be something simple!
Actually, using the proprietary MONEY is a huge problem. It does not divide or multiply correctly. It does...
--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 22, 2010 at 11:40 am

#1197042
RE: Importing Tab Delimited Flat Files Using SSIS

kscott-851323 (7/22/2010)
Hello,
I have multiple SSIS packages importing data from flat files that are tab delimited. The issue I am having is the source files column position can change without...
--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 22, 2010 at 11:35 am

#1197037
RE: Importing Tab Delimited Flat Files Using SSIS

sturner (7/22/2010)
I would bulk insert this file into a stage table first then do the insert into the production table by specifying the column names in the order you want...
--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 22, 2010 at 11:32 am

#1197036
RE: more cores vs higher CPU speed

You also have to think about licensing costs which may or may not be at the core level.
--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 22, 2010 at 11:23 am

#1197029
RE: Cursor within DTS

Chris Morris-439714 (7/21/2010)
Even if there is a clustered index on the table in the order that the update is supposed to be executed, there's no guarantee that the rows will...
--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 22, 2010 at 11:06 am

#1197013
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

peter-757102 (7/22/2010)
Mike C (7/21/2010)
Jeff Moden (7/21/2010)
Mike C (7/20/2010)
I'll have to look a little closer at that one tomorrow. Is multirow variable aggregation as unsafe as multirow string concatenation?
Gosh, Mike,...
--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 22, 2010 at 8:04 am

#1196866
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/21/2010)
Jeff Moden (7/21/2010)
Mike C (7/20/2010)
I'll have to look a little closer at that one tomorrow. Is multirow variable aggregation as unsafe as multirow string concatenation?
Gosh, Mike, I'm...
--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 22, 2010 at 8:00 am

#1196864
RE: Sub query expressions vs. Joins.

Steve Jones,
If you see this, I believe this article needs an "Interesting Discussion" flag.
--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 22, 2010 at 7:35 am

#1196845
RE: Sub query expressions vs. Joins.

Mike Carey-249880 (7/22/2010)
would like to see how these queries perform using CTE instead
Heh... so write the CTE's and let's see the test results, Mike. The author did provide 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)

July 22, 2010 at 7:23 am

#1196836
RE: Sub query expressions vs. Joins.

I agree with Johannes Krackowizer... the two queries are not the same. The correlated subquery is effectively an outer join. After a bit of repair to make both...
--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 22, 2010 at 7:05 am

#1196825
RE: Sub query expressions vs. Joins.

glen.Gorman (7/22/2010)
I was thinking something is missing from this article, and whats missing is the reasoning why joins are generally better than sub queries. The reasoning give you more...
--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 22, 2010 at 6:50 am

#1196813
RE: Fixed length columns

Ram:) (7/21/2010)
Hi,
Sorry.. I was reposted this before Lynn's reply.. Thanks everybody and Lynn..
Please correct me on using replicate..
Ah... understood.
Either way is fine for performance.... the CAST method is a bit...
--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 21, 2010 at 12:23 pm

#1196400
RE: Add dash to data

Adam Haines (7/21/2010)
I agree with Joe that this should be done in the presentation/application layer. I understand that sometimes this is beyond your control. If you absolutely must...
--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 21, 2010 at 12:21 pm

#1196394
RE: importing text files with " " around the text

alen teplitsky (7/21/2010)
thx
as soon as i got rid of that quote it went further than line 3 and to line 41. now i have to check the entire file which...
--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 21, 2010 at 12:20 pm

#1196392
RE: Recursive CTE to replace a cursor problem

Robb Melancon (7/20/2010)
Hey Jeff,
I have read through the discussion pages related to your article titled "Solving the Running Total & Ordianl Rank Problems". There is also another thread 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)

July 21, 2010 at 12:13 pm

#1196382

Viewing 15 posts - 37,561 through 37,575 (of 59,098 total)