Viewing 15 posts - 1,216 through 1,230 (of 1,415 total)
awesome!
According to the technet page http://technet.microsoft.com/en-us/library/ms176102.aspx it looks like you could actually eliminate the "partition by 1" part, so might be worth it to try fiddling with the rank functionality...
January 10, 2014 at 8:59 am
"PARTITION BY e.business_unit " will reset that ranking functionality back to 1 for each change of business_unit, maybe try "PARTITION BY 1" instead?
January 10, 2014 at 8:43 am
Dooooooooooo (12/12/2013)
USE [ABC]
GO
DECLARE@return_value int
EXEC@return_value = [dbo].[test]
@QTRSTRTDATE = N'select CONVERT(datetime,DATEADD("M", DATEDIFF("M", 0, GETDATE()), 0),120)',
@QTRENDDATE = N'select CONVERT(datetime,DATEADD("M",DATEDIFF("M",-1, GETDATE()),-1),120)'
SELECT'Return Value' = @return_value
GO
i get the below...
December 12, 2013 at 8:08 am
Jeff Moden (12/11/2013)
patrickmcginnis59 10839 (12/11/2013)
Awesome writeup Jeff! Worthy of an article submission IMHO!
Thank you kind Sir. My only question would be, does it sufficiently answer your good question as...
December 11, 2013 at 9:18 am
Awesome writeup Jeff! Worthy of an article submission IMHO!
December 11, 2013 at 6:12 am
ZZartin (12/10/2013)
patrickmcginnis59 10839 (12/10/2013)
ZZartin (12/10/2013)
patrickmcginnis59 10839 (12/10/2013)
PHYData DBA (12/10/2013)
patrickmcginnis59 10839 (12/9/2013)
Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If...
December 10, 2013 at 3:20 pm
ZZartin (12/10/2013)
patrickmcginnis59 10839 (12/10/2013)
PHYData DBA (12/10/2013)
patrickmcginnis59 10839 (12/9/2013)
Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not the...
December 10, 2013 at 1:13 pm
PHYData DBA (12/10/2013)
patrickmcginnis59 10839 (12/10/2013)
PHYData DBA (12/10/2013)
patrickmcginnis59 10839 (12/9/2013)
Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not...
December 10, 2013 at 12:09 pm
PHYData DBA (12/10/2013)
patrickmcginnis59 10839 (12/9/2013)
Well thats what I was wondering, then and now. What makes RBAR so slow if its not the language? If its not the language, then cursors...
December 10, 2013 at 11:19 am
Jim P. (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Just to make sure I have the analogy correct, which data operation do I equate with the walk to the trash can?The Commit Transaction step
No penalty...
December 9, 2013 at 9:08 pm
ZZartin (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
ZZartin (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
December 9, 2013 at 8:43 pm
Charles Kincaid (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Now this is interesting, because doing the running totals thing would be awesome in a cursor! Would a cursor based solution beat the triangular join method?...
December 9, 2013 at 7:12 pm
peter-757102 (12/9/2013)
Charles Kincaid (12/9/2013)
RBAR fetches more rows from the table. False. It has...
December 9, 2013 at 6:05 pm
ZZartin (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
I didn't see any explanation on why RBAR is so slow, so rated this article 1 star.
This is how...
December 9, 2013 at 5:15 pm
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
Jeff Moden (12/9/2013)
patrickmcginnis59 10839 (12/9/2013)
I didn't see any explanation on why RBAR is so slow, so rated this article 1 star.
This is how RBAR comes to...
December 9, 2013 at 3:52 pm
Viewing 15 posts - 1,216 through 1,230 (of 1,415 total)