Viewing 15 posts - 53,686 through 53,700 (of 59,068 total)
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. 😉
December 7, 2007 at 7:33 pm
Charles Kincaid (12/7/2007)
December 7, 2007 at 7:31 pm
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...
December 7, 2007 at 7:26 pm
...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...
December 7, 2007 at 7:59 am
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...
December 7, 2007 at 7:43 am
Christian Buettner (12/7/2007)
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...
December 7, 2007 at 7:36 am
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...
December 6, 2007 at 11:14 pm
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...
December 6, 2007 at 11:06 pm
...yes, to Oracle 😛
Heh... you're a sick man, Corey 🙂 ... I hate Oracle... 😉
December 6, 2007 at 10:59 pm
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...
December 6, 2007 at 10:54 pm
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...
December 6, 2007 at 10:46 pm
This was an awesome articles and it spawned a great discussion.
But the question of whether or not you can disregard the physical layer depends on your goal. In most cases...
December 6, 2007 at 10:41 pm
I would disagree with your assertion that set based programming is code that touches rows once or very few times and that the query you specified is not set based....
December 6, 2007 at 10:25 pm
TheSQLGuru (12/6/2007)
December 6, 2007 at 9:56 pm
Thanks for the feedback, Matt... and thanks for the "missing link" info... I just fixed it.
December 6, 2007 at 12:26 pm
Viewing 15 posts - 53,686 through 53,700 (of 59,068 total)