Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,496 through 12,510 (of 59,095 total)

RE: Refreshing lower environments with prod copy

Get your infrastructure folks to automate SAN snapshots for you. They're nearly instantaneous.
--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)

April 23, 2018 at 9:34 am

#1987908
RE: Clustered Index Online Rebuild?????

kevaburg - Monday, April 23, 2018 8:12 AM
Hi folks,
a really interesting fact has been mentioned to me today in so far as...
--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)

April 23, 2018 at 8:22 am

#1987901
RE: Are the posted questions getting worse?

Ed Wagner - Monday, April 23, 2018 7:51 AM
ChrisM@Work - Monday, April 23, 2018 2:34 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)

April 23, 2018 at 7:53 am

#1987896
RE: Suggestions for managing multi-tenant SQL Azure database (esp.restore)

I've gotta agree with Grant... doing partial table restores for a given Client would make some serious sucking sounds. Having 1 database per client also has the advantages of extreme security...
--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)

April 23, 2018 at 7:48 am

#1987893
RE: user typed "begin transaction" and went home

coolchaitu - Monday, April 23, 2018 4:45 AM
ThomasRushton - Monday, April 23, 2018 3:04 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)

April 23, 2018 at 7:43 am

#1987891
RE: Are the posted questions getting worse?

Rick-153145 - Monday, April 23, 2018 4:12 AM
Steve Jones - SSC Editor - Friday, April 20, 2018...
--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)

April 23, 2018 at 7:38 am

#1987888
RE: Are the posted questions getting worse?

jonathan.crawford - Friday, April 20, 2018 7:01 PM
Jeff Moden - Friday, April 20, 2018 1:05 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)

April 23, 2018 at 7:23 am

#1987885
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 10:44 PM
Jeff Moden - Sunday, April 22, 2018 9:47 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)

April 22, 2018 at 10:48 pm

#1987839
RE: Unable to get format file to work

p.s. Almost without exception, I load files to a staging table first so that I can validate data, check for duplicates, etc, yada, yada. With that in mind, I also...
--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)

April 22, 2018 at 9:47 pm

#1987837
RE: Unable to get format file to work

No problem. Thank you for the feed back. Excluding fields in the file is pretty easy... assign them a column number of 0 (zero) and give them a unique...
--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)

April 22, 2018 at 9:43 pm

#1987836
RE: Select All Records Where Date Falls Within Next Week

Between knowing that day "0" is the first of January, 1900 and that day was a Monday along with a little integer math and a little direct date math, 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)

April 22, 2018 at 9:34 pm

#1987835
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 9:13 PM
Jeff Moden - Sunday, April 22, 2018 9:08 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)

April 22, 2018 at 9:15 pm

#1987833
RE: Unable to get format file to work

Jeff Moden - Sunday, April 22, 2018 9:08 PM
ron.abbott - Sunday, April 22, 2018 8:25 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)

April 22, 2018 at 9:13 pm

#1987831
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 8:25 PM
The txt file was generated by a software package that I am unfamiliar with.
Not sure...
--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)

April 22, 2018 at 9:08 pm

#1987829
RE: Unable to get format file to work

I was able to duplicate the error even after adding the / n. Looking...
--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)

April 22, 2018 at 8:23 pm

#1987826

Viewing 15 posts - 12,496 through 12,510 (of 59,095 total)