Why Scalar Functions Can Be Costly
Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.
2017-06-02 (first published: 2016-01-04)
13,177 reads
Scalar UDF
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
6,969 reads
T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses
A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.
2013-11-28
6,824 reads
Format Currency Into a String
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,029 reads
SQL Server Functions: The Basics
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
2008-12-12 (first published: 2008-11-19)
837 reads
Calculating the Number of Business Hours Passed Since a Point of Time
A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.
2011-09-21 (first published: 2007-11-20)
3,072 reads
Payment due date function
Calculates the nth due date for any given date, while accounting for weekends.
2012-05-16 (first published: 2007-10-11)
2,975 reads
RE: Two fields into one
CREATE VIEW YourView AS SELECT FirstName + ' ' + LastName AS FirstLast from YourTable
2004-09-03
RE: image files
Check the reference to Microsoft ActiveX Data Objects and make certain you are using a library version which supports the stream object ( 2.5 or higher )
2004-07-07
Blogs
Creating a user for a STONITH resource in vSphere
I previously blogged about how to create a STONITH resource for a pacemaker cluster...
Default event_file path for Extended Events
By Zikato
Foreword Have you ever wondered where the .xel file is saved when you create a...
Query Store Hints in SQL Server 2022
Another neat little feature in SQL Server 2022 is Query Store Hints. This is...
Forums
Package runs in Debug mode but fails otherwise
Hi We have a SSIS package that uploads data to Blob storage. The package...
Can anyone suggest a plan with backup full and backup log without backup diff ?
I need only one backup full at mid night, and one backup log each...
Restore data for a single tenant in a multi tenant DB
Our OLTP is being converted from a one tenant per database structure to a...
Ask SSC