Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag RBAR Rss

   Items 1 to 3 of 3   
 

GetNumsAB

A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.  Read more...
By Alan Burstein 2016/04/19 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 545 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 | 17,713 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 | 17,713 reads
   Items 1 to 3 of 3   
 
Tags
itzik ben-gan (1)    
nasty fast (1)    
numbers (1)    
numbers function (1)    
row_number (1)    
set based (1)    
tally table (1)    
t-sql (1)    
user defined functions (1)    
user-defined functions (1)