Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,161 through 14,175 (of 59,101 total)

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
RE: The Achilles Heel

Heh... I won't mention the name of the company that I think you're talking about but its initials are "Equifax" 😛
I can't believe that the CEO of...
--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 6, 2017 at 9:48 pm

#1962717
RE: Data Modelers - Alternatives to Erwin

Grant Fritchey - Wednesday, June 18, 2014 6:52 AM
Clay Bowen (6/17/2014)
You fail to mention the price of Embarkadero is actually higher than...
--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 6, 2017 at 9:37 pm

#1962716
RE: Data Modelers - Alternatives to Erwin

halil.lacevic - Friday, October 6, 2017 5:30 PM
So far, I have tried many online tools. However, I will list you some of...
--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 6, 2017 at 9:32 pm

#1962715
RE: Data Modelers - Alternatives to Erwin

Brandie Tarvin - Tuesday, January 29, 2008 11:45 AM
I just downloaded a trial version of this and it won't open any of...
--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 6, 2017 at 9:31 pm

#1962714
RE: Why SQL Server is Better Than Oracle

First of all, you say that the partitioning was so that you could achieve parallelism in your ETL loads to the staging table. You also state that the partitioned was...
--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 6, 2017 at 9:06 pm

#1962713
RE: Using Date in Where Condition

aloshya - Friday, October 6, 2017 8:03 AM
John Mitchell-245523 - Friday, October 6, 2017 7:59 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 6, 2017 at 5:42 pm

#1962712
RE: Rewrite Your Code Tomorrow

I came across this article after about 50 views, according the stats on the website. At that time, this article only had about 3 stars. Considering all the great comments...
--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 6, 2017 at 5:11 pm

#1962708
RE: Teaching Quickly

When writing articles or even presentations, I've found that demonstrating a "bad" way saves on a huge number of questions (and, contrary to popular belief, there is such a thing 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)

October 6, 2017 at 4:59 pm

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

TheCTEGuy - Friday, October 6, 2017 6:50 AM
Phil Parkin - Friday, October 6, 2017 6:43 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 6, 2017 at 3:03 pm

#1962703

Viewing 15 posts - 14,161 through 14,175 (of 59,101 total)