Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag User-Defined Functions Rss

   Items 1 to 2 of 2   

How to Make Scalar UDFs Run Faster (SQL Spackle)

It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.  Read more...
By Jeff Moden 2012/08/01 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,918 reads

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: | Category: etl
Rating: |  Discuss |   Briefcase | 1,218 reads
   Items 1 to 2 of 2   
delimiters (1)    
etl (1)    
integration services (ssis) (1)    
parsing column data (1)    
rbar (1)    
string manipulation (1)    
truncation (1)    
t-sql (1)    
user defined functions (1)