Jeff Moden

Forum Replies Created

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

RE: error in backup encryption

Hopefully you didn't just publish a real password. 😉
--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 5:04 pm

#1987959
RE: Need to add MMM-yyyy to end of file in exp.builder-SSIS

ZZartin - Monday, April 23, 2018 3:31 PM
Why are you doing this in SSIS at all, this can be done in 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)

April 23, 2018 at 4:53 pm

#1987957
RE: Need to add MMM-yyyy to end of file in exp.builder-SSIS

I'll also state that you'll really, really end up hating yourself or someone will end up hating you if you use the format of MMM-yyyy for this because it's flat...
--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 3:03 pm

#1987944
RE: Are the posted questions getting worse?

Rick-153145 - Monday, April 23, 2018 7:49 AM
Jeff Moden - Monday, April 23, 2018 7:38 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 12:17 pm

#1987927
RE: Spills into tempdb poor performing query fixed by converting to SP

SQL Bandit - Monday, April 23, 2018 4:33 AM
declare @accountId0 bigint = 1719,
@status1 int = 11,
@senderDone2 bit = 0,
@PreviewMode3 bit...
--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 12:12 pm

#1987926
RE: SQL 2014 Standard - Reindex DB Processing Time

cmp119 - Monday, April 23, 2018 10:56 AM
At the end of each month I reindex a critical financial database on a...
--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 11:23 am

#1987923
RE: Refreshing lower environments with prod copy

Feivel - Monday, April 23, 2018 11:02 AM
Jeff Moden - Monday, April 23, 2018 9: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 11:08 am

#1987921
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

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