Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,001 through 15,015 (of 59,101 total)

RE: Looking for best approach

autoexcrement - Tuesday, May 23, 2017 9:29 AM
FULL OUTER JOIN?
That was my first thought.
--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)

May 23, 2017 at 4:46 pm

#1943904
RE: Naming Conventions for the Cloud

Steve Jones - SSC Editor - Tuesday, May 23, 2017 8:49 AM
xsevensinzx - Tuesday, May 23, 2017...
--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)

May 23, 2017 at 4:24 pm

#1943903
RE: To Delete / Truncate / Drop & Create

RonKyle - Tuesday, May 23, 2017 7:43 AM
RonKyle - Thursday, May 18, 2017 7:08 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)

May 23, 2017 at 1:40 pm

#1943883
RE: To Delete / Truncate / Drop & Create

Sean Lange - Tuesday, May 23, 2017 7:59 AM
That isn't a natural key. It is using a surrogate key from another...
--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)

May 23, 2017 at 1:34 pm

#1943881
RE: To Delete / Truncate / Drop & Create

RonKyle - Tuesday, May 23, 2017 10:49 AM
I often get the feeling I'm the only person who still reads Dr. Codd'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)

May 23, 2017 at 1:32 pm

#1943879
RE: To Delete / Truncate / Drop & Create

jcelko212 32090 - Tuesday, May 23, 2017 10:36 AM
RonKyle - Tuesday, May 23, 2017 8:17 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)

May 23, 2017 at 1:25 pm

#1943877
RE: float to date

Eirikur Eiriksson - Tuesday, May 23, 2017 6:29 AM
Chipping in, float and datetime are compatible, in fact the conversion between the two...
--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)

May 23, 2017 at 8:44 am

#1943808
RE: Are the posted questions getting worse?

Phil Parkin - Monday, May 22, 2017 6:00 PM
Anyone in the mood for talking about RAM requirements while remaining tight-lipped about 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)

May 22, 2017 at 10:19 pm

#1943685
RE: RAM Required to run SQL Server + Web Application + SSIS packages

parth83.rawal - Monday, May 22, 2017 5:13 PM
Yes, the design of the pages are such that Nolock will have hardly have impact...
--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)

May 22, 2017 at 10:09 pm

#1943684
RE: t-sql 2012 parse out multiple values in one field that is varchar(1200)

Jeff Moden - Sunday, May 21, 2017 11:22 AM
wendy elizabeth - Saturday, May 20, 2017 8:22 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)

May 22, 2017 at 9:51 pm

#1943683
RE: To Delete / Truncate / Drop & Create

RonKyle - Thursday, May 18, 2017 7:08 AM
Often there is a natural key for employees or people. Often there is not...
--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)

May 22, 2017 at 7:19 pm

#1943681
RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

Ed Wagner - Monday, May 22, 2017 12:16 PM
Well, it's now up to 20 yes to 1 no.
Heh... dollars to donuts 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)

May 22, 2017 at 2:27 pm

#1943656
RE: The Human Impact of a Capable AI

Steve Jones - SSC Editor - Monday, May 22, 2017 10:57 AM
xsevensinzx - Monday, May 22, 2017...
--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)

May 22, 2017 at 12:09 pm

#1943619
RE: The Human Impact of a Capable AI

Steve Jones - SSC Editor - Sunday, May 21, 2017 7:57 PM
There are certainly places where AI like systems have replaced humans...
--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)

May 21, 2017 at 11:44 pm

#1943502
RE: The Human Impact of a Capable AI

Steve Jones - SSC Editor - Friday, May 19, 2017 10:45 AM
Eric M Russell - Tuesday, May...
--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)

May 21, 2017 at 4:18 pm

#1943491

Viewing 15 posts - 15,001 through 15,015 (of 59,101 total)