Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,431 through 8,445 (of 59,072 total)

Reply To: STRING_SPLIT with Index as Table-Valued Function

bteague wrote:
Absolutely and all fair points, but until SQL Server finally supports the "occurence" argument as Oracle has for a while in its INSTR function, I'll use this as 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)

November 2, 2019 at 7:07 pm

#3694096
Reply To: Non-technical question

I agree with Grant and Mike. I would especially agree with Grant about troubleshooting code being part of the tasks of the DBA of the future but that is and...
--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)

November 2, 2019 at 6:58 pm

#3694095
Reply To: A Mindset Shift

I don't share your optimism nor point of view here, Steve. We've seen MS remove functionality from SSMS with absolutely no warning. We seen MS publish cumulative updates that 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)

November 2, 2019 at 1:20 am

#3694028
Reply To: last day of the month minus 1 day

This reminds me of a certain well known personality that denounces the use of engine-proprietary functionality because someone somewhere someday may have to use the code in another RDBMS and...
--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)

November 1, 2019 at 6:45 pm

#3693919
Reply To: last day of the month minus 1 day

I guess I don't understand why anyone would write software based on the knowledge of novices. If it's important for a novice to be able to maintain something 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)

November 1, 2019 at 5:38 am

#3693737
Reply To: Are the posted questions getting worse?

Eirikur Eiriksson wrote:
Jo Pattyn wrote:
Eirikur Eiriksson, sorry to hear about your crystall ball. I hope it cristallizes again. Perhaps with the hourglass bbq of Steve.
This is how it looks like, kind...
--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)

October 31, 2019 at 7:47 pm

#3693667
Reply To: Is SSIS really that bad?

MVDBA (Mike Vessey) wrote:
by the way - has anyone twigged that permission management for SSIS is a pile of garbage?
Not in that vein but I have said that it's an unnecessary expansion...
--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)

October 31, 2019 at 7:42 pm

#3693666
Reply To: Is SSIS really that bad?

x wrote:
If I can ever get SSIS to work, I'm hoping to start using it, I used to love bcp, other forms of bulk loads etc, but our systems got...
--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)

October 31, 2019 at 2:11 pm

#3693551
Reply To: Is SSIS really that bad?

MVDBA (Mike Vessey) wrote:
SSIS is not as bad as people make out, purely because people don't know how to use it. I think DTS was better (but im an old guy) -
Spot...
--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)

October 31, 2019 at 1:44 pm

#3693530
Reply To: Oops, I deleted that data

I once told a friend, I aim to please... I sometimes miss but I'm always aiming. I'm humbled by your comment. Thank you for the very kind feedback.
--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)

October 31, 2019 at 1:19 am

#3693352
Reply To: Convert European format values to US Format

jcelko212 32090 wrote:
This should not be a problem at the database tier in your tiered architecture. Do this in the input, before it even gets near the tables. You'll find ETL...
--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)

October 30, 2019 at 6:54 pm

#3693241
Reply To: Insert with trigger works with cursor, not set

ScottPletcher wrote:
Or re-create the index so that it allows multiple NULLs but no other dups.
Apparently, the morning coffee hasn't kicked in for me yet today... what would the CREATE INDEX...
--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)

October 30, 2019 at 5:47 pm

#3693212
Reply To: Convert European format values to US Format

What is the datatype of the original data you want to convert?
--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)

October 30, 2019 at 5:39 pm

#3693207
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Haha Jeff. I do spend a lot more time than I would like writing managed code. But this is the same third party vendor's code who has this as...
--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)

October 30, 2019 at 5:34 pm

#3693206
Reply To: Oops, I deleted that data

alex.sqldba wrote:
Oh yah. Had this. Only to be told by the Lead Developer that its a 'best practice' and that 'I wouldn't understand'
So, I made my case and then let...
--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)

October 30, 2019 at 4:02 pm

#3693175

Viewing 15 posts - 8,431 through 8,445 (of 59,072 total)