Jeff Moden

Forum Replies Created

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

RE: Who Likes NULL?

Heh... always fun to watch discussions concerning 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)

July 13, 2018 at 1:57 pm

#1997549
RE: Table design considerations help

vsamantha35 - Thursday, July 12, 2018 4:33 AM
Hi All,
This is a general question regarding database design. I am not a db...
--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 13, 2018 at 1:53 pm

#1997548
RE: Are the posted questions getting worse?

JaybeeSQL - Thursday, July 12, 2018 8:14 AM
I have met NOBODY in the last 2 years who was a Brexit voter,...
--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 12, 2018 at 8:52 am

#1997312
RE: The SQL Joke Thread

below86 - Wednesday, July 11, 2018 2:59 PM
sgmunson - Wednesday, July 11, 2018 1:54 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)

July 11, 2018 at 4:08 pm

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

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