Jeff Moden

Forum Replies Created

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

RE: Importing XML Files into a flat table

Luke L - Friday, July 13, 2018 12:08 PM
It's next on my list as a POC, but since the XML Datatype 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 13, 2018 at 8:55 pm

#1997575
RE: Who Likes NULL?

Matt Miller (4) - Friday, July 13, 2018 2:27 PM
Jeff Moden - Friday, July 13, 2018 1:57...
--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 6:27 pm

#1997573
RE: DBCC FREEPROCCACHE

Steve Jones - SSC Editor - Friday, July 13, 2018 3:24 PM
Looking for a basic article on how to use this, especially...
--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 6:26 pm

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

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