Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,031 through 15,045 (of 59,097 total)

RE: To Delete / Truncate / Drop & Create

RonKyle - Monday, May 15, 2017 1:59 PM
If you run In a transaction without committing, yes
Try it for yourself
I can't think...
--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)

May 15, 2017 at 7:57 pm

#1942638
RE: To Delete / Truncate / Drop & Create

jcelko212 32090 - Monday, May 15, 2017 1:34 PM
The major difference between delete and truncate is that delete is a standard...
--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)

May 15, 2017 at 6:45 pm

#1942637
RE: convert string YYYYMM into date SSIS

Phil Parkin - Monday, May 15, 2017 10:14 AM
Jeff Moden - Monday, May 15, 2017 9:57 AM
--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)

May 15, 2017 at 6:34 pm

#1942636
RE: convert string YYYYMM into date SSIS

Luis Cazares - Monday, May 15, 2017 8:12 AM
Jeff Moden - Monday, May 15, 2017 7:51 AM
--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)

May 15, 2017 at 9:57 am

#1942590
RE: To Delete / Truncate / Drop & Create

stephen.plant - Monday, May 15, 2017 6:52 AM
TheSQLGuru - Monday, May 15, 2017 5:51 AM
--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)

May 15, 2017 at 8:01 am

#1942552
RE: convert string YYYYMM into date SSIS

joanna.seldon - Monday, May 15, 2017 7:36 AM
Hi
that is a good point
I would use the 01 (First) of the month please
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)

May 15, 2017 at 7:51 am

#1942549
RE: SSIS Security concerning the File System, Execute Process, and Script Tasks

Awesome. Many thanks for the help.
Your answer on question 2 brings up one additional question...
2. Is there anything that...
--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)

May 15, 2017 at 7:46 am

#1942545
RE: Dealing with programmers

roger.plowman - Monday, May 15, 2017 7:10 AM
Maybe it's just because I've always been a lone wolf developer, but I haven't...
--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)

May 15, 2017 at 7:35 am

#1942542
RE: Are the posted questions getting worse?

jasona.work - Monday, May 15, 2017 6:08 AM
Ed Wagner - Sunday, May 14, 2017 6:40 PM
--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)

May 15, 2017 at 6:42 am

#1942524
RE: Dealing with programmers

Matt Miller (4) - Sunday, May 14, 2017 7:39 PM
Jeff Moden - Sunday, May 14, 2017 12:52...
--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)

May 14, 2017 at 8:24 pm

#1942471
RE: Best option for working with Files in SSIS

@calbimonte.Daniel,
Except for the previously stated bit of confusion in the Conclusion of the article, I liked the article. It was 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)

May 14, 2017 at 3:00 pm

#1942466
RE: Best option for working with Files in SSIS

Brent Leslie - Sunday, May 14, 2017 4:19 AM
Ahhh... don't your results and conclusion contradict themselves?
Results:
"The File System task is the worst...
--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)

May 14, 2017 at 1:32 pm

#1942465
RE: Dealing with programmers

Matt Miller (4) - Sunday, May 14, 2017 11:52 AM
Jeff Moden - Sunday, May 14, 2017 8:49...
--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)

May 14, 2017 at 12:52 pm

#1942464
RE: Dealing with programmers

roger.plowman - Friday, May 12, 2017 12:28 PM
Jeff Moden - Wednesday, May 10, 2017 1:07 PM
--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)

May 14, 2017 at 8:49 am

#1942462
RE: Removing Brackets Along with Text from Column

Sergiy - Saturday, May 13, 2017 7:38 PM
Jeff, I'd prefer to use ' [' instead of '[' as a split point.It's 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)

May 13, 2017 at 9:28 pm

#1942452

Viewing 15 posts - 15,031 through 15,045 (of 59,097 total)