Jeff Moden

Forum Replies Created

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

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
RE: Getting rid of duplicate records

natividad.castro - Thursday, August 3, 2017 3:55 PM
Thanks all for your reply.
Group by won't work you're still pulling all four records.
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 5, 2017 at 5:35 am

#1954221
RE: The Tethered Goat

Heh... instead of talking about such an intrusion detector, Red Gate should make one.
--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 5, 2017 at 5:18 am

#1954220
RE: Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL

Iwas Bornready - Thursday, October 22, 2015 7:44 AM
The task I have is to identify where in my daily sql I can...
--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 4, 2017 at 11:19 pm

#1954218
RE: Looking Back

bdcoder - Friday, August 4, 2017 10:33 PM
TomThomson - Friday, August 4, 2017 5:57 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 4, 2017 at 10:58 pm

#1954217

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