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 3 of 3   
 

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 2014/06/24 (first published: 2012/08/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,279 reads

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 2014/06/24 (first published: 2012/08/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,279 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: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,262 reads
   Items 1 to 3 of 3   
 
Tags
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)