Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,686 through 53,700 (of 59,072 total)

RE: Using data sources - Best Practise

Copy only the data you need for the report from the linked server into a local table... then, do the reporting off that and drop the table when you are...
--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)

December 7, 2007 at 10:55 pm

#758266
RE: Disk Sace Usage

Yes... you haven't DECLARED @db_name...
--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)

December 7, 2007 at 10:51 pm

#758265
RE: SQL for numeric ranges

Then, try this...
http://www.sqlservercentral.com/articles/Advanced+Querying/anefficientsetbasedsolutionforislandsandgaps/1619/
--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)

December 7, 2007 at 9:45 pm

#758262
RE: Hidden RBAR: Triangular Joins

Thank you, Jeff - from now on I will more-closely watch my use of inline queries.
Taking what Larry Taylor said a little bit further --
Jeff clearly states that...
--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)

December 7, 2007 at 7:36 pm

#758260
RE: Hidden RBAR: Triangular Joins

Sergey Kazachenko (12/7/2007)
Adam Machanic liked a cursor-based solution for running sums:
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx
I like Adam... so I won't hold that against him. 😉
--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)

December 7, 2007 at 7:33 pm

#758259
RE: Hidden RBAR: Triangular Joins

Charles Kincaid (12/7/2007)
On another tack, pronouncing it ree-bar got a good laugh in the staff meeting the other day. I was asked if I'm researching data or putting 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)

December 7, 2007 at 7:31 pm

#758257
RE: Hidden RBAR: Triangular Joins

It makes it difficult to have a conversation when people refuse to use well-established meanings for particular terms.
Heh... But that's my whole point... I believe that what you and 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)

December 7, 2007 at 7:26 pm

#758256
RE: Hidden RBAR: Triangular Joins

...how certain types of UDFs can also lead to "RBAR" executions, e.g., when applying a UDF to a column to extend the results of your SELECT.
That's a spot-on observation... and...
--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)

December 7, 2007 at 7:59 am

#758094
RE: Hidden RBAR: Triangular Joins

Does a inner join (for that matter any join) with a inequality condition in the where clause make a triangular join.
Yes, but in the presence of other criteria, it can...
--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)

December 7, 2007 at 7:43 am

#758088
RE: Hidden RBAR: Triangular Joins

Christian Buettner (12/7/2007)
Hi Jeff, Chirag,
I am not sure if I misunderstood something, but the SQL Statement does NOT utilize a "triangular join":
Select orderid,orderdate,productid
from orders O INNER JOIN orderdetails OD
On O.orderid...
--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)

December 7, 2007 at 7:36 am

#758084
RE: Hidden RBAR: Triangular Joins

On the other hand, if your goal is for elegant well written code above all, especially in a more purely theoretical setting, then you can largely if not completely ignore...
--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)

December 6, 2007 at 11:14 pm

#757959
RE: Hidden RBAR: Triangular Joins

Does a inner join (for that matter any join) with a inequality condition in the where clause make a triangular join.
Yes, but in the presence of other criteria, it can...
--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)

December 6, 2007 at 11:06 pm

#757957
RE: Hidden RBAR: Triangular Joins

...yes, to Oracle 😛
Heh... you're a sick man, Corey 🙂 ... I hate Oracle... 😉
--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)

December 6, 2007 at 10:59 pm

#757955
RE: Hidden RBAR: Triangular Joins

By the way - that's processing that grows a a slower rate than linearly proportional to the cardinalty of the universe you're operating in.
Again, very well said... if 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)

December 6, 2007 at 10:54 pm

#757953
RE: Hidden RBAR: Triangular Joins

But by not considering the physical aspect, or how the logical applies to it, you will eventually build something that left to its own devices will do just that (saturate...
--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)

December 6, 2007 at 10:46 pm

#757952

Viewing 15 posts - 53,686 through 53,700 (of 59,072 total)