Viewing 15 posts - 2,551 through 2,565 (of 8,416 total)
UMG Developer (9/25/2010)
What about the performance difference between passing in a NVARCHAR(MAX) and NVARCHAR(4000)?
That can make a difference, yes. It used to be the case that SQLCLR functions that...
September 25, 2010 at 12:38 am
UMG Developer (9/25/2010)
One question, why does this version not have the "TableDefinition" in the "Microsoft.SqlServer.Server.SqlFunction" definition? Is it not required?
It's only used by Visual Studio during auto-deployment (Professional Edition and...
September 25, 2010 at 12:22 am
Ok, this one produces integers. I chose to return NULL if the input string contains elements that aren't integers.
CREATE ASSEMBLY [Utility]
...
September 24, 2010 at 11:39 pm
steve-893342 (9/24/2010)
Unless BETWEEN is more efficient here, you just need the LESS THAN
I tend to agree. I'm patiently waiting for Jeff to post the new Tally code in full...
September 24, 2010 at 10:38 pm
UMG Developer (9/24/2010)
So as far as I can tell 4199 is the only trace flag to use going forward. (Assuming you need any fix released after trace flag 4133)
Hmm, for...
September 24, 2010 at 10:33 pm
UMG Developer (9/24/2010)
For this one, but for other modifications I would need to build it unless you want to make all the test versions for me.
No I don't 😛
If you...
September 24, 2010 at 10:30 pm
The Dixie Flatline (9/24/2010)
Interestingly, Bob's query, while undeniably compact, still scans the source table twice.
You fail to ascertain that performance was not my primary design criterion. 😛
I'm trying not...
September 24, 2010 at 6:41 am
The Dixie Flatline (9/23/2010)
September 24, 2010 at 5:47 am
Chris Morris-439714 (9/24/2010)
September 24, 2010 at 3:55 am
Chris Morris-439714 (9/24/2010)
:blush: I don't see it Paul...
Yours is the only one to return the new row (item 'D').
As I read the first post, the task is to return rows...
September 24, 2010 at 3:35 am
UMG Developer (9/23/2010)
I know I should just test this, I might if I had the tools installed and knew how to make/build CLRs...
If you trust me, you can just run...
September 24, 2010 at 12:48 am
UMG Developer (9/23/2010)
September 24, 2010 at 12:38 am
Chris, I think your query returns incorrect results if we add a single extra item to the sample data:
CREATE TABLE #t1
(
...
September 24, 2010 at 12:14 am
The Dixie Flatline (9/23/2010)
September 23, 2010 at 11:57 pm
Anyone have any idea why I felt the need to try to reinvent COUNT(*) OVER using RANK and MAX?
Thanks Chris.
September 23, 2010 at 7:30 am
Viewing 15 posts - 2,551 through 2,565 (of 8,416 total)