Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,631 through 9,645 (of 59,102 total)

RE: Backup Restorations

But it's not everything after the DIF. That's what transaction log files are used for... to decrease the RPO.
--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)

March 20, 2019 at 9:22 am

#2025028
RE: Minimal Logging

Ah... my apologies. I didn't read one of your previous posts completely to find out that you are, indeed, doing your secondary inserts in an "Append Only" fashion. That post...
--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)

March 20, 2019 at 9:04 am

#2025024
RE: trimming SSNs

RonKyle - Wednesday, March 20, 2019 6:45 AM
I read something that asymmetric encryption was resource intensive and that the recommended solution is...
--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)

March 20, 2019 at 7:01 am

#2025009
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

Eirikur Eiriksson - Wednesday, March 20, 2019 6:14 AM
Jeff Moden - Wednesday, March 20, 2019 5:37 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)

March 20, 2019 at 6:43 am

#2025003
RE: Split strings by space into individual rows

pietlinden - Tuesday, March 19, 2019 2:18 PM
Yeah... I was having a fit trying to get the formatting etc to work. Does...
--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)

March 20, 2019 at 5:51 am

#2024998
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

Jonathan AC Roberts - Wednesday, March 20, 2019 5:34 AM
Jeff Moden - Wednesday, March 20, 2019 5:21...
--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)

March 20, 2019 at 5:40 am

#2024996
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

Eirikur Eiriksson - Wednesday, March 20, 2019 5:32 AM
Jeff Moden - Wednesday, March 20, 2019 5:21 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)

March 20, 2019 at 5:37 am

#2024995
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Eirikur Eiriksson - Tuesday, March 19, 2019 8:52 AM
Jeff Moden -...
--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)

March 20, 2019 at 5:33 am

#2024993
RE: Get the distinct records which having same date with different time stamp.

Jonathan AC Roberts - Tuesday, March 19, 2019 9:09 AM
Or you could use Jeff's favourite method: 😛

declare @trend table (keyinstn...
--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)

March 20, 2019 at 5:27 am

#2024991
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

Jonathan AC Roberts - Tuesday, March 19, 2019 4:02 PM
cubangt - Tuesday, March 19, 2019 3:26 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)

March 20, 2019 at 5:21 am

#2024990
RE: trimming SSNs

ScottPletcher - Tuesday, March 19, 2019 2:23 PM
RonKyle - Tuesday, March 19, 2019 1:30 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)

March 20, 2019 at 5:16 am

#2024989
RE: Varchar(Max) storage

DinoRS - Tuesday, March 19, 2019 8:49 AM
Jeff Moden - Tuesday, March 19, 2019 8: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)

March 19, 2019 at 11:26 pm

#2024968
RE: Get the distinct records which having same date with different time stamp.

kbhanu15 - Tuesday, March 19, 2019 8:02 AM
thank you it is working fine.
This won't be the last time you run into this. ...
--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)

March 19, 2019 at 8:43 am

#2024907
RE: Allocate Meetings to Employees (randomly generated) with daily maximum hours set at 5

jonathan.crawford - Tuesday, March 19, 2019 8:22 AM
Might I suggest that nobody is looking for true "random assignment", they want it 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)

March 19, 2019 at 8:42 am

#2024906
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

I've not worked with Netezza before. To be honest, I've heard of it before but never dug in to find what it was all about. It turns out to be...
--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)

March 19, 2019 at 8:37 am

#2024905

Viewing 15 posts - 9,631 through 9,645 (of 59,102 total)