Month: December 2016

Work around to scalar functions – SQL Server

There is no harm in using the Scalar UDF’s if it is used for Arithmetic operation or other purposes which doesn’t involves accessing any table. Always create such Scalar UDF’s with SCHEMABINDING to avoid Spooling. But, Scalar UDF’s are not good option if it is accessing the table. Let us evaluate the above statement. We … Continue reading Work around to scalar functions – SQL Server