Jeff Moden

Forum Replies Created

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

RE: DBA Challenge! I've spent 4 hours trying to figure how to extract data from XML in a hierarchical form.

With no reflection on the OP because he's the poor consumer of this data and not the perpetrator... you just have to wonder what the heck is on people's minds...
--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 17, 2017 at 6:00 am

#1942871
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, May 17, 2017 5:09 AM
Brandie Tarvin - Wednesday, May 17, 2017 4:47 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 17, 2017 at 5:33 am

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

Perry Whittle - Tuesday, May 16, 2017 3:16 AM
Jeff Moden - Tuesday, May 16, 2017 2:47 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 16, 2017 at 9:49 am

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

Perry Whittle - Tuesday, May 16, 2017 1:20 AM
I agree, you probably won't even use it but the statement that a truncate...
--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 16, 2017 at 2:47 am

#1942657
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

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