Viewing 3 posts - 1 through 3 (of 3 total)
Surely other factors like CPU, Memory and Disk Configuration could affect these timings, hence why from my tests the XML was a better fit. There probably isn't one size fits...
March 7, 2011 at 2:34 am
#1295211
I find the below faster on 2005.
[font="Courier New"]
CREATE FUNCTION [Strings].[fnStringSplit_2005_Distinct_CHAR]
(
@SourceString VARCHAR(MAX)
)
/*======================================================================================
'P System ...
February 25, 2011 at 1:20 am
#1291395
Surely adding a constraint when designing the table is the best option.
Stop duplicates at source?
May 27, 2008 at 5:41 am
#820465