Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,216 through 49,230 (of 59,091 total)

RE: Two jobs run same time one has to wait.

You're looking at the code that SQL Server generated to run some user code... better if you look at the user code. Look for long transactions to begin 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 13, 2008 at 11:55 am

#842119
RE: Performance Issue with when Proc called thru SSIS "SQL Task"

Just a side bar... if the job is taking 4 hours on anything to run, you might want to look at tuning the code instead of trying to tune SSIS....
--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 13, 2008 at 11:51 am

#842117
RE: What's an MVP?

Heh... cgnospam words are pretty strong and most folks who have an MVP would certainly be upset about being called a "marketing whore" or maybe even an "evangelist" :hehe:, 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)

July 13, 2008 at 11:46 am

#842115
RE: Split data

You already said that... this is the third time... relax... someone else will answer...
--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 13, 2008 at 10:54 am

#842106
RE: Two jobs run same time one has to wait.

It's just me, but I'd forget about spending any further time on that... it's time to start looking at the code and fixing it. You already know that they...
--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 13, 2008 at 10:42 am

#842104
RE: Launching Excel VBA from SSIS?

Eric,
You're a good man... you came on board with a question that, obviously, no one else is able to answer and you continue to post your findings. All 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)

July 13, 2008 at 10:39 am

#842103
RE: Split data

You'll find that double posting within a thread will piss people off worse than normal double posting. 😉
--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 13, 2008 at 10:32 am

#842101
RE: Split data

That was the recommendation I made above... so, Yes.
--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 13, 2008 at 10:27 am

#842099
RE: Validate Date

It was at least that long ago for me as well... and I could also have a failing memory ...
I guess the good thing is... we don't have to...
--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 12, 2008 at 8:25 pm

#842046
RE: ERROR: String o binary data would be truncated

Uh huh... are those the same executives that think "Bananas in Pajamas" is an appropriate title for a kids' show? :hehe:
--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 12, 2008 at 8:05 pm

#842044
RE: Analytical Interview Questions

Loner (7/12/2008)
The second one was I had to build a data warehouse. I would get data from different outside sources. Each one would give me a text delimited file...
--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 12, 2008 at 11:01 am

#842010
RE: ERROR: String o binary data would be truncated

Oh, I love those words! "Stuffed up"... I've got an Irish friend at work who says they "buggered it up"... if people only know how nasty those words really...
--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 12, 2008 at 10:57 am

#842008
RE: What's an MVP?

cgnospam (7/12/2008)
MVP for the most part is a marketing whore.
There are a lot of companies that do it. They pick pick online "evangelists" on forums and use them to...
--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 12, 2008 at 10:02 am

#842000
RE: Coming In August

Heh... as you well know, it doesn't have to be something new to be abused... look at cursors and While loops... look at people storing dates as formatted Varchars... people...
--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 12, 2008 at 9:53 am

#841999
RE: Working part-time

Heh... if you want a part time job that will really keep your skills sharp, get a copy of the Developer's Edition of SQL Server and answer 10,000+ posts on...
--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 12, 2008 at 9:48 am

#841997

Viewing 15 posts - 49,216 through 49,230 (of 59,091 total)