Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,626 through 14,640 (of 59,101 total)

RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 1:02 PM
Jeff Moden - Tuesday, August 8, 2017 12:38 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)

August 8, 2017 at 2:18 pm

#1954539
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 12:04 PM
Phil Parkin - Tuesday, August 8, 2017 11:57 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)

August 8, 2017 at 12:45 pm

#1954531
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 11:56 AM
Jeff Moden - Tuesday, August 8, 2017 11:42 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)

August 8, 2017 at 12:38 pm

#1954530
RE: Fixing Plan Issues in the Middle of the Night

From the headline:
Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to...
--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)

August 8, 2017 at 12:04 pm

#1954525
RE: The Current Date

David Conn - Monday, August 7, 2017 1:14 AM
I see comments in this post trying to justify the old legacy DateTime Data...
--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)

August 8, 2017 at 11:50 am

#1954517
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 7:12 AM
You could also disable all your constraints and then re-enable them afterwards
-- disable all...
--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)

August 8, 2017 at 11:42 am

#1954513
RE: BCP upload from a txt file

sqlenthu 89358 - Friday, August 4, 2017 7:21 AM
Hi Guys,
I an trying to do a simple upload from a txt file to...
--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)

August 8, 2017 at 11:22 am

#1954508
RE: Looking Back

bdcoder - Sunday, August 6, 2017 8:29 PM
TomThomson - Sunday, August 6, 2017 7:20 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)

August 6, 2017 at 10:04 pm

#1954260
RE: Looking Back

bdcoder - Sunday, August 6, 2017 5:20 PM
Jeff Moden - Sunday, August 6, 2017 4:37 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)

August 6, 2017 at 10:00 pm

#1954257
RE: Looking Back

TomThomson - Sunday, August 6, 2017 4:44 PM
Jeff Moden - Friday, August 4, 2017 7:27 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)

August 6, 2017 at 9:55 pm

#1954256
RE: Looking Back

bdcoder - Sunday, August 6, 2017 12:01 PM
Jeff Moden - Sunday, August 6, 2017 11:28 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)

August 6, 2017 at 4:37 pm

#1954248
RE: Full backup size is very high

If you constantly backup to the same file and you don't have it set to overwrite, then you have every backup you ever made appended to the same file. 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)

August 6, 2017 at 12:06 pm

#1954244
RE: Looking Back

bdcoder - Sunday, August 6, 2017 10:51 AM
Jeff Moden - Sunday, August 6, 2017 10:35 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)

August 6, 2017 at 11:28 am

#1954241
RE: The Tethered Goat

Heh... true enough. Liability and "weasel clauses" are a big deterrent. I especially like the ones that boil down to "we own the software and you're not allowed to publish...
--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)

August 6, 2017 at 10:42 am

#1954239
RE: Looking Back

bdcoder - Sunday, August 6, 2017 9:31 AM
TomThomson - Sunday, August 6, 2017 6:45 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)

August 6, 2017 at 10:35 am

#1954238

Viewing 15 posts - 14,626 through 14,640 (of 59,101 total)