Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,006 through 40,020 (of 59,098 total)

RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Thanks for the response, Dan.
Yep, I know that you can't have a two (or more) table source (well... Merge Join almost does that). I have an OLE DB source...
--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)

February 2, 2010 at 3:52 pm

#1112562
RE: Alphanumberic string search

BrainDonor (2/2/2010)
sql_ques (2/2/2010)
Please tell me how to do it.
No.
I will however take as long as is required to help you to work out how to write it. That is...
--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)

February 2, 2010 at 3:37 pm

#1112557
RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Oh yeah... almost forgot. While this seems to be a "natural" for replication, one of the requirements is to not use replication. I also can't simply use 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)

February 2, 2010 at 3:29 pm

#1112553
RE: UPSERT USING SSIS 2005

Hey there Ritz... I sure do hope you're still around because I need some help that your very good Word document just isn't helping me with. Would you take...
--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)

February 2, 2010 at 3:25 pm

#1112551
RE: Indexing a Large Table

roelofsleroux (2/2/2010)
Its basically to avoid JOIN statements.
It may be convenient to use but all you've done is avoid having to write JOIN statements. It's still doing a join 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)

February 2, 2010 at 6:14 am

#1112221
RE: Why moving a database slowed it down a lot?

george sibbald (2/2/2010)
Hmmm. Having trouble wrapping my head around this one. I hope its not true or everything I hold dear about backups turns out to be a lie. I...
--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)

February 2, 2010 at 6:01 am

#1112211
RE: Date Range

Sorry Arun... language barrier thing is interfering a bit. I didn't ask a question so I'm not sure what you mean.
--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)

February 1, 2010 at 10:05 pm

#1112075
RE: Indexing a Large Table

I agree with that. That's why we want to see that slow query and the execution plan for it. We're just shooting in the dark until that happens.
--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)

February 1, 2010 at 10:01 pm

#1112074
RE: Deciding whether adding RAM will help performance

I'm not sure on how to demonstrate the benefit of additional RAM without actually buying it and show how it does or does not make an improvement.
So far...
--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)

February 1, 2010 at 9:55 pm

#1112072
RE: Date Range

There will be no such animal as 2010-02-29. 😉
Arun... you beat me to 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)

February 1, 2010 at 9:23 pm

#1112066
RE: T-SQL Stored Proc calling T-SQL Function

mark.veitch (2/1/2010)
The following is our T-SQL function that is being called for all VarChar,Char,NChar and NVarChar fields in our SELECT statement in a stored proc. There is a lot...
--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)

February 1, 2010 at 9:12 pm

#1112064
RE: Stored Proc with table variables running very slow?

Another good idea. Thanks Wayne. Just curious though... have you ever used it that way?
--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)

February 1, 2010 at 9:00 pm

#1112063
RE: Need to break up a single row into multiple rows

Why wouldn't UNPIVOT (maybe, more than one) do the job here?
--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)

February 1, 2010 at 8:59 pm

#1112062
RE: Keeping It All In Memory

It's ironic... as someone once said, "The more things change, the more they stay the same". Holy shades of "RAM DISK", Batman! 😛
--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)

February 1, 2010 at 8:55 pm

#1112061
RE: How do I do an update/insert to certain fields in a certain order?

mohaminho10 (2/1/2010)
It is actually going to update more that 5 DB's...the total runs to about 25 DB's.
Does anyone have a sample code that I can take a look at?
Thanks
Simple...
--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)

February 1, 2010 at 6:28 pm

#1112038

Viewing 15 posts - 40,006 through 40,020 (of 59,098 total)