Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,616 through 9,630 (of 59,091 total)

RE: sql job taking more time

HandyD - Monday, March 11, 2019 5:55 PM
Jeff Moden - Monday, March 11, 2019 6:39 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 21, 2019 at 6:36 am

#2025095
RE: Using recursive CTE

Sachy123 - Thursday, March 21, 2019 4:53 AM
drew.allen - Friday, March 15, 2019 12: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 21, 2019 at 6:24 am

#2025093
RE: SQL Server slow but CPU,Memory and Network fine

kapfundestanley - Thursday, March 21, 2019 5:35 AM
Team please looking for assistance on SQL Server 2016,CPU,Memory and Network are fine but application...
--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 21, 2019 at 6:18 am

#2025092
RE: The transaction log for database is full due to 'ACTIVE_TRANSACTION'

Orni - Wednesday, March 13, 2019 11:53 AM
Hi all,
I am an accidental DBA that has been assigned to monitor and optimize 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)

March 20, 2019 at 6:16 pm

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

Viewing 15 posts - 9,616 through 9,630 (of 59,091 total)