Viewing 15 posts - 16 through 30 (of 67 total)
BTW, on a production test.
I had to run Jeff's running total update because I had 80 million rows to group by 1,928,672 different accounts over a 7 year period.
1.5 minute...
February 19, 2008 at 1:03 pm
This I guess may be in way on and off topic...
But what if you wanted to age them?
And what if you wanted to age them based on the max(Date) for...
February 19, 2008 at 12:51 pm
Sir Slicendice (2/19/2008)
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...
February 19, 2008 at 12:44 pm
>>When I do training, I've found that most people do not remember a thing when you cater to being politically correct or explaining things.
>>They do remember bad examples and the...
February 19, 2008 at 11:53 am
Kinda like finding chicken's teeth and my chicken just flew away to a different state.
Eh.... What? :blink:
---
Frank & Kevin both bring up some very valid points though with the...
February 19, 2008 at 11:27 am
I would recommend Microsoft Press Inside Microsoft SQL Server 2005 T-SQL Querying.
ISBN: 0735623139
That will help you tremendously in getting up to speed on SQL 2005 as well as your troubleshooting...
February 19, 2008 at 11:05 am
TheSQLGuru (2/19/2008)
February 19, 2008 at 10:37 am
Matt Miller (2/19/2008)
ALZDBA (2/19/2008)
Thanks 🙂OT bis
Is there an "common CLR pittfals" link somewhere ?
I haven't found a good one yet.
The short list I have is this:
-...
February 19, 2008 at 10:29 am
Jeff Moden (2/19/2008)
Heh... LMAO! Now that's funny, Chris! Ya know... I bet it would sell like hotcakes with a title like that!
Slightly OT rant:
Seriously though, you cannot find...
February 19, 2008 at 10:17 am
Jeff Moden (2/19/2008)
Heh... LMAO! Now that's funny, Chris! Ya know... I bet it would sell like hotcakes with a title like that!
I bet it would. =)
February 19, 2008 at 10:03 am
Jeff Moden (2/19/2008)
I have fooled around with some UDF replacements such as calculating
date ranges, .... and I've been amazed how fast this works on CLR.
I'd be real interested in knowing...
February 19, 2008 at 9:48 am
ALZDBA (2/19/2008)
Christopher Ford (2/19/2008)...
pipe.SendResultsStart(row);
...
February 19, 2008 at 8:02 am
Bah, forget it...
It takes too long to run streaming 1 million rows to the result pane...or doing an insert.
However, this code should make a great learning snippet for anyone wanting...
February 19, 2008 at 2:30 am
Nice....
I did it...copying code from Matt in order to post time differences.
used StoredProcedure.
CLR Table Valued Functions or User Defined Functions cannot pipe results directly to the client, so you must...
February 19, 2008 at 1:34 am
BTW, wouldn't the RowID go increasing by date in this test case?
98% of the time, you wouldn't run into a situation where RowID 9876 is an earlier date than RowID...
February 18, 2008 at 11:25 pm
Viewing 15 posts - 16 through 30 (of 67 total)