Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,651 through 7,665 (of 59,072 total)

Reply To: Introduction to STRING_SPLIT function in SQL

First of all, I appreciate it when anyone puts the time and effort into writing and publishing an article, so thank you very much for that. Keep writing.
As you've seen...
--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)

March 3, 2020 at 4:38 am

#3730439
Reply To: What Happened to Hadoop?

Eric M Russell wrote:
Jeff Moden wrote:
Eric M Russell wrote:
HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide -...
--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)

March 2, 2020 at 9:07 pm

#3730349
Reply To: What Happened to Hadoop?

Matt Miller (4) wrote:
Jeff Moden wrote:
Eric M Russell wrote:
HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide -...
--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)

March 2, 2020 at 9:00 pm

#3730342
Reply To: Casting Tiny Numbers

Steve Jones - SSC Editor wrote:
This question isn't designed to cover all possibilities. Writing questions like that is hard and fraught with perils. You are welcome to submit your own questions about other types...
--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)

March 2, 2020 at 8:51 pm

#3730340
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Phil Parkin wrote:
This is a tidy approach, but I'd have concerns, from an audit point of view, about data having been manipulated before it even hits the database. Potentially makes 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)

March 2, 2020 at 4:31 pm

#3730224
Reply To: What Happened to Hadoop?

Eric M Russell wrote:
HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide - one 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)

March 2, 2020 at 4:20 pm

#3730208
Reply To: Casting Tiny Numbers

Good basic question, Steve. My only objection would be the title of the question itself because this also occurs for much larger numbers and larger VARCHARs.

--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)

March 2, 2020 at 3:00 pm

#3730172
Reply To: Indexed view using remote database

Most people want to make indexed views for performance purposes which, of course, don't work on remote servers because of the schema binding issue.
If you don't really need it 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)

March 1, 2020 at 8:29 pm

#3729984
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

@andrew Goffin-302397 ,
I realize the your post has been hijacked, so I'm still trying to get it back on track but I need that bit of info I've been asking...
--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 29, 2020 at 9:55 pm

#3729884
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

BHWAAA-HAAAAAAA!!!! And... it doesn't use curly braces. 😀
--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 29, 2020 at 9:52 pm

#3729883
Reply To: Data Orchestration

skeleton567 wrote:
I just rejected a new version of software I've used for decades because it now requires that I connect to internet each time I use it. Ain't gonna happen.
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 29, 2020 at 1:36 am

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

MVDBA (Mike Vessey) wrote:
Lynn Pettis wrote:
MVDBA (Mike Vessey) wrote:
Lynn Pettis wrote:
MVDBA (Mike Vessey) wrote:
I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) 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)

February 28, 2020 at 11:15 pm

#3729767
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Jeffrey Williams wrote:
I think we went backwards...
I especially agree with that sentiment.
--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 28, 2020 at 7:47 pm

#3729706
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Personally, I'm REALLY happy that the whole world hasn't adopted EDI. IMHO, it's another hierarchical nightmare of data that's even worse than things like "packed decimal".
This is what I'm talking...
--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 28, 2020 at 7:06 pm

#3729691
Reply To: Returning Info from Stored Procedures

I got it right only because I mentally limited the question to "typical documented" methods. It's also why I hate tests. It's like asking the question of "Which is 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)

February 28, 2020 at 4:40 pm

#3729643

Viewing 15 posts - 7,651 through 7,665 (of 59,072 total)