Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,146 through 14,160 (of 59,095 total)

RE: Comparing 2 functions for any differences in the result set.

ffarouqi - Monday, October 9, 2017 10:42 AM
TheCTEGuy - Friday, October 6, 2017 4:53 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)

October 9, 2017 at 10:46 am

#1962862
RE: The Worms-eye View

TomThomson - Wednesday, October 4, 2017 10:45 AM
Jeff Moden - Monday, October 2, 2017 9:59 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)

October 9, 2017 at 12:52 am

#1962783
RE: query format

MinhL7 - Sunday, October 8, 2017 3:19 PM
This is just dummy data to show how I need the data displayed in 3...
--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)

October 8, 2017 at 11:45 pm

#1962781
RE: query format

And what logic is supposed to change "Chef" to "Food Services"?
--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)

October 8, 2017 at 2:15 pm

#1962772
RE: IO and drive latency

coolchaitu - Sunday, October 8, 2017 7:24 AM
Jeff Moden - Sunday, October 8, 2017 7:19 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)

October 8, 2017 at 8:07 am

#1962757
RE: IO and drive latency

coolchaitu - Sunday, October 8, 2017 7:07 AM
Jeff Moden - Saturday, October 7, 2017 2: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)

October 8, 2017 at 7:19 am

#1962755
RE: Why SQL Server is Better Than Oracle

kannan_egd - Saturday, October 7, 2017 12:00 AM
Dear Jeff Moden,
Thanks for the response. The Drives provided by us are taken from two...
--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)

October 7, 2017 at 9:33 pm

#1962749
RE: SQl to calculate average time for call centre agents

Zalouncha - Saturday, October 7, 2017 1:37 AM
Jeff Moden - Saturday, October 7, 2017 1:22 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)

October 7, 2017 at 9:21 pm

#1962748
RE: Using Date in Where Condition

ChrisM@home - Saturday, October 7, 2017 3:25 PM
Phil Parkin - Saturday, October 7, 2017 9:47 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)

October 7, 2017 at 9:10 pm

#1962747
RE: IO and drive latency

I've found that about 99.9% of the time, it's not the hard disk a latency turns out to be a bit of a lie. It's normally bad code that can't...
--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)

October 7, 2017 at 2:37 pm

#1962742
RE: Why Don't You Unit Test Code?

David.Poole - Friday, October 6, 2017 2:07 AM
My experience is that people in IT abdicate their power and authority. Many of 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)

October 7, 2017 at 11:54 am

#1962740
RE: Comparing 2 functions for any differences in the result set.

TheCTEGuy - Friday, October 6, 2017 11:35 PM
Jeff - Thanks for that article. It seems rCTEs are a performance bottlenecks. But...
--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)

October 7, 2017 at 11:07 am

#1962739
RE: Using Date in Where Condition

John Mitchell-245523 - Friday, October 6, 2017 10:02 AM
Zidar - Friday, October 6, 2017 9: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)

October 7, 2017 at 7:55 am

#1962728
RE: SQl to calculate average time for call centre agents

Zalouncha - Saturday, October 7, 2017 1:37 AM
Jeff Moden - Saturday, October 7, 2017 1:22 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)

October 7, 2017 at 7:42 am

#1962727
RE: SQl to calculate average time for call centre agents

Zalouncha - Friday, October 6, 2017 9:53 AM
Hi Thom A,
Do you mean the Create script for the table hosting the data?
if so...
--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)

October 7, 2017 at 1:22 am

#1962720

Viewing 15 posts - 14,146 through 14,160 (of 59,095 total)