Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,046 through 18,060 (of 59,069 total)

RE: The New Men of IT

GeorgeCopeland (3/19/2016)
CV is a common business term and it is used extensively in academia. I prefer qualifications brief .
Heh... I refer to both a "CV" (Curricula Vitae) and 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)

March 19, 2016 at 12:42 pm

#1866284
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/19/2016)
Jeff,
I 100% agree with you that his test script wasn't the best. His number table splitter you've already dressed down, and that xml splitter doesn't do any lob caching...
--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 19, 2016 at 8:17 am

#1866265
RE: Find a String in a String

quagmired (3/19/2016)
Jeff Moden (3/18/2016)
quagmired (3/18/2016)
Jeff Moden (3/18/2016)
quagmired (3/17/2016)
Parting thought: how would you match a 1 followed by an arbitrary number of 0s followed by a 1 with T-SQL?
Starting thought.... Have...
--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 19, 2016 at 7:12 am

#1866261
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/18/2016)
Also sqlperformance article seems to suggest the thing performs fairly well...
http://sqlperformance.com/2016/03/t-sql-queries/string-split
Obviously, his t-sql and xml based splitters are poor choices.
Whomever wrote the numbers table splitter doesn't have a clue...
--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 18, 2016 at 11:03 pm

#1866249
RE: Find a String in a String

quagmired (3/18/2016)
Jeff Moden (3/18/2016)
quagmired (3/17/2016)
Parting thought: how would you match a 1 followed by an arbitrary number of 0s followed by a 1 with T-SQL?
Starting thought.... Have you ever actually...
--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 18, 2016 at 9:57 pm

#1866247
RE: Find a String in a String

Jeff Moden (3/18/2016)
quagmired (3/17/2016)
Parting thought: how would you match a 1 followed by an arbitrary number of 0s followed by a 1 with T-SQL?
Starting thought.... Have you ever actually had...
--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 18, 2016 at 9:30 pm

#1866246
RE: 0 is equal to zero length string. Can someone explain how this can be?

Matt Miller (#4) (3/18/2016)
Just because CSV didn't provide a way to notate NULL vs '' (or rather you and your data provided didn't agree on a way to convey NULL)...
--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 18, 2016 at 9:14 pm

#1866245
RE: Typing Spelling error check

Luis Cazares (3/18/2016)
I agree with all that has been said. But, maybe you could make it work implementing Full-Text Search? This is only if you already have problems with this...
--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 18, 2016 at 8:17 pm

#1866244
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Goldie Lesser (3/18/2016)
Ed Wagner (3/17/2016)
If it doesn't have a sequence number, I wont be using it. 'Nuff said.
I use Jeff's function all the time, and I can't even 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)

March 18, 2016 at 3:27 pm

#1866227
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Eirikur Eiriksson (3/18/2016)
mburbea (3/18/2016)
see this post from Paul White :
http://www.sqlservercentral.com/Forums/FindPost1570980.aspx
Paul White (5/14/2014)
Is everyone running Jeff's original/updated test rig from the article to get these results?
If so, you might not be...
--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 18, 2016 at 3:06 pm

#1866220
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/18/2016)
see this post from Paul White :
http://www.sqlservercentral.com/Forums/FindPost1570980.aspx
Paul White (5/14/2014)
Is everyone running Jeff's original/updated test rig from the article to get these results?
If so, you might not be testing what...
--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 18, 2016 at 3:05 pm

#1866218
RE: Find a String in a String

quagmired (3/17/2016)
Parting thought: how would you match a 1 followed by an arbitrary number of 0s followed by a 1 with T-SQL?
Starting thought.... Have you ever actually had to do...
--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 18, 2016 at 1:39 pm

#1866202
RE: Find hierarchyID from different parts of a node?

@yb751,
NP. Glad the SortPath helped! Thanks for the 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)

March 18, 2016 at 1:36 pm

#1866201
RE: Building Better Software

Gary Varga (3/18/2016)
Jeff Moden (3/17/2016)
In a similar vein... it's not possible for some companies to build better software because of the apparent incredible lack of even basic talent out there....
--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 18, 2016 at 9:03 am

#1866163
RE: Building Better Software

Rod at work (3/18/2016)
And where are you interviewing?
Troy, Michigan.
--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 18, 2016 at 9:00 am

#1866161

Viewing 15 posts - 18,046 through 18,060 (of 59,069 total)