Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,486 through 37,500 (of 59,072 total)

RE: Sub query expressions vs. Joins.

Gianluca Sartori (7/26/2010)
Jeff Moden (7/26/2010)
Gianluca Sartori (7/26/2010)
A minor note on the Oracle thing: it used to be completely rule-based, but now it's entirely cost-based. Starting from version 10g the rule-based...
--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)

July 26, 2010 at 6:42 am

#1198166
RE: summing up the previous row values up to date level

jprabha.d (7/24/2010)
Thanks For the Solution i used Running value Function that is in SSRS,
A wise choice... how is it in the area of performance?
--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)

July 26, 2010 at 6:37 am

#1198162
RE: Sub query expressions vs. Joins.

Gianluca Sartori (7/26/2010)
A minor note on the Oracle thing: it used to be completely rule-based, but now it's entirely cost-based. Starting from version 10g the rule-based optimizer is no longer...
--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)

July 26, 2010 at 6:34 am

#1198158
RE: Sub query expressions vs. Joins.

cmapowers (7/25/2010)
This seems to be a correlated sub-query. Does this apply to non correlated sub-query?
All non correlated sub-queries break down to being an inline view whether they're in 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)

July 26, 2010 at 6:32 am

#1198157
RE: Are the posted questions getting worse?

Gianluca Sartori (7/26/2010)
Tom.Thomson (7/26/2010)
Gianluca Sartori (7/26/2010)
Microsoft dumbness??? This reminds me of a recent discussion on TRY/CATCH...:-P
(Just kidding, not trying to compare any of you to Mr. Doobya, but I couldn'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)

July 26, 2010 at 6:16 am

#1198146
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

vadnal.vijaykumar (7/26/2010)
Hi Jeff
Thanks for the informative article.
But with this same posting, I am currently working on some Reports using ASP.NET and SQL Server. I want to populate data from 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)

July 26, 2010 at 6:11 am

#1198145
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Heh... the more I learn of this subject and similar subjects especially when the human element is included, the more I realize that there's one and only one premise in...
--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)

July 25, 2010 at 2:04 pm

#1197967
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Matt Miller (#4) (7/25/2010)
Jeff - I believe you're looking for the October 1985 article series in Computerworld, by Codd, entitled:
Does your DBMS Play by the rules
From Codd's own description...
--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)

July 25, 2010 at 1:39 pm

#1197963
RE: Recursive CTE to replace a cursor problem

CELKO (7/22/2010)
When I worked at a Mormon owned technical school, I was referred to as "ethical diversity in the faculty" and loved it.
Heh... oddly enough, I can see that actually...
--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)

July 25, 2010 at 1:34 pm

#1197962
RE: spliting a varchar(max) into multiples

Thanks, Steve... I'll have to "give it a go" myself (no pun intended). 😉
--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)

July 25, 2010 at 1:27 pm

#1197961
RE: Sub query expressions vs. Joins.

hrc_public (7/25/2010)
.. glad I always try to avoid the use of subqueries in my applications.
Ummmm.... why? We just proved that the article is incorrect and that certain correctly formed...
--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)

July 25, 2010 at 1:08 pm

#1197960
RE: Sum Daily Data Into Weekly Data

Novicejatt (7/23/2010)
I get data daily for same code, so its repeating and I have 30 such codes which means that I have 30 codes with same date. So no Column...
--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)

July 25, 2010 at 1:03 pm

#1197959
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/23/2010)
I'm in total agreement with you 99.9% of the time on just about every topic Jeff, and you know that well. The fact that people spend 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)

July 25, 2010 at 12:58 pm

#1197957
RE: Using Format File with IDENTITY COLUMN

Like I said in my previous post, there MUST be a length for the 35th field and you MUST not specify any filed or row delimiters in your bulk insert...
--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)

July 25, 2010 at 12:46 pm

#1197956
RE: Math function question

Oh... I almost forgot... special kudos to you on the "tone" of this one, Joe. Very well done and very much appreciated.
--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)

July 24, 2010 at 9:22 am

#1197869

Viewing 15 posts - 37,486 through 37,500 (of 59,072 total)