Viewing 3 posts - 1 through 4 (of 4 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...
Cheap toilet paper is a false economy, beware!
March 7, 2011 at 2:34 am
I find the below faster on 2005.
[font="Courier New"]
CREATE FUNCTION [Strings].[fnStringSplit_2005_Distinct_CHAR]
(
@SourceString VARCHAR(MAX)
)
/*======================================================================================
'P System ...
Cheap toilet paper is a false economy, beware!
February 25, 2011 at 1:20 am
Surely adding a constraint when designing the table is the best option.
Stop duplicates at source?
Cheap toilet paper is a false economy, beware!
May 27, 2008 at 5:41 am
Viewing 3 posts - 1 through 4 (of 4 total)