Jeff Moden

Forum Replies Created

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

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
RE: t-sql 2012 parse out multiple values in one field that is varchar(1200)

wendy elizabeth - Saturday, May 20, 2017 8:22 PM
Yes there is a table where the canned statements are stored at. The problem...
--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:22 am

#1943483
RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

Hugo Kornelis - Sunday, May 21, 2017 3:03 AM
Jeff Moden - Saturday, May 20, 2017 2:33...
--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:20 am

#1943482
RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. ...
--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 20, 2017 at 2:33 pm

#1943450
RE: Are the posted questions getting worse?

Shifting gears a bit and referring to the following post...
https://www.sqlservercentral.com/Forums/1877279/BEFORE-TRIGGER-Idea-Posted-to-Microsoft-Connect
I worked with Oracle for about 3 years. In general, I have no love for it BUT it...
--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 20, 2017 at 2:29 pm

#1943449

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