Viewing 15 posts - 16 through 30 (of 42 total)
Charles Kincaid (7/14/2008)
You said:
I think it's fascinating that we have this huge business...
July 14, 2008 at 9:19 am
Interesting article, but I think you (and to be fair, lots of others) have missed one of the most valuable benefits of XML:
The standardized hierarchical nature makes it very, very...
May 2, 2008 at 10:57 am
Why is it that in today's world we expect users to be able to patch and manage their own computer?
How many people out there, tech-heads included, fully 'manage' and 'patch'...
April 21, 2008 at 8:27 am
bhovious (3/31/2008)
March 31, 2008 at 10:24 am
Steve,
Your "realistic" savings calculated with the numbers you give are off by an order of magnitude -- should be $2,260, not the $21,259 in your e-mail.
On the bright side, the...
March 31, 2008 at 10:13 am
Nice article.
Does anyone know if AS in SS08 supports the HierarchyID type for parent-child hierarchies? There's a lot of very specific logic in AS for the current linkage (ID...
March 25, 2008 at 11:33 am
The TVF would run faster and be far more portable than relying on pushing the button; the button could move or be removed at any point..... But if you...
February 19, 2008 at 9:00 pm
Choosing whether or not to store some aggregate value (anything that can be calculated based on the fundamental data) depends on a lot of factors -- statutory requirements, how often...
February 19, 2008 at 4:58 pm
Well, you sure can age these: all line items for the 10 accounts that have the longest period without a transaction and that have a positive current balance:
select rttl.*, accts.age,...
February 19, 2008 at 1:44 pm
5) It would be quite an interesting finding if the TVF did indeed 'encourage' more parallelism than without. Oh, great function name too, btw! hehehe
Yes, indeed it does. ...
February 19, 2008 at 12:30 pm
As a wrap-up of the CTE approach from my perspective:
Building on the last set of code I posted (the TVF version), compare a view on the TVF with the TVF...
February 19, 2008 at 12:12 pm
Just to add one more bit on this:
Over the w/e, I was curious how the engine would handle these queries as a view or as a TVF; the view was...
February 19, 2008 at 11:46 am
I bet most of you don't know the neutron lifecycle (throwback from my Nuclear Navy days 🙂 ) but it isn't because you aren't smart enough to know it. ...
February 19, 2008 at 11:04 am
Jeff,
Sorry, I should have posted the group by time as well; it's about the same as yours, 800msec or so. I agree that using the partitioned sum as a...
February 15, 2008 at 8:41 pm
1) SELECT ... OVER(ORDER BY...) does guarantee the order by in the OVER but does NOT IIRC guarantee the order of the SELECT output.
If you're refering to the CTE approach...
February 15, 2008 at 8:13 pm
Viewing 15 posts - 16 through 30 (of 42 total)