Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,881 through 11,895 (of 59,095 total)

RE: Who Likes NULL?

Dennis Q Miller - Wednesday, July 11, 2018 10:29 AM
I'm afraid we're getting mired in a quagmire of discordant definitions...
NULL is...
--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)

July 11, 2018 at 10:52 am

#1997161
RE: STRING and FIND SQL Functions

Thanks, Pedro. I'll take a look.
--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)

July 11, 2018 at 10:50 am

#1997160
RE: Who Likes NULL?

Dennis Q Miller - Wednesday, July 11, 2018 8:23 AM
You are illustrating how NULL is prone to coding error. The first...
--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)

July 11, 2018 at 8:28 am

#1997137
RE: Who Likes NULL?

ZZartin - Wednesday, July 11, 2018 7:59 AM
It depends but the big difference between NULL and magic values is that NULLs...
--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)

July 11, 2018 at 8:24 am

#1997135
RE: STRING and FIND SQL Functions

Sigh... and so it goes. :discuss:
--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)

July 11, 2018 at 8:07 am

#1997130
RE: Who Likes NULL?

drew.allen - Tuesday, July 10, 2018 2:50 PM
Having been involved in Y2K compliance, I make sure that my "magic values" will...
--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)

July 10, 2018 at 3:31 pm

#1997077
RE: Who Likes NULL?

drew.allen - Tuesday, July 10, 2018 10:27 AM
Codd discussed two different types of unknown values: Unknown but applicable and Unknown 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)

July 10, 2018 at 1:14 pm

#1997051
RE: Who Likes NULL?

Steve Jones - SSC Editor - Tuesday, July 10, 2018 8:40 AM
For dates, I don't see an alternative. A separate column is...
--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)

July 10, 2018 at 9:18 am

#1996994
RE: Ensuring Each Client has a Full Set of Key-Value Pairs

alen teplitsky - Tuesday, July 10, 2018 8:00 AM
Jeff Moden - Tuesday, July 10, 2018 7:37 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)

July 10, 2018 at 8:24 am

#1996968
RE: Ensuring Each Client has a Full Set of Key-Value Pairs

Don't you "love" it when someone rates an article as a "2" (the rating I encountered I first saw the posting) and doesn't take the time to explain why they rated...
--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)

July 10, 2018 at 7:37 am

#1996945
RE: Urgent! - How to extract number from a string

dva2007 - Tuesday, July 10, 2018 6:55 AM
After reading the article above I used dbo.DigitsOnlyEE which is very quick.
Exactly. That's...
--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)

July 10, 2018 at 7:31 am

#1996942
RE: Who Likes NULL?

Romac - Tuesday, July 10, 2018 2:34 AM
chrisbray - Tuesday, July 10, 2018 2:09 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)

July 10, 2018 at 7:02 am

#1996938
RE: Urgent! - How to extract number from a string

dva2007 - Tuesday, July 10, 2018 5:24 AM
I already used the function given by Jeff dbo.fnLeaveOnly. Both of...
--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)

July 10, 2018 at 6:39 am

#1996934
RE: Data compression

I'm about a week from compressing a 1.4 TeraByte database to about 400GB and a 1 Terabyte database to slightly less than that... and I'm not using CCI and I'm...
--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)

July 9, 2018 at 8:10 pm

#1996890
RE: The GDPR is Coming to the US

Victor Kirkpatrick - Monday, July 9, 2018 12:54 PM
Hopefully the US does not follow Europe's overreaching business-crunching GDPR edict. There's already enough...
--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)

July 9, 2018 at 8:05 pm

#1996889

Viewing 15 posts - 11,881 through 11,895 (of 59,095 total)