Functions User Defined UDF

Troubleshoot SQL Server User-Defined Function performance issues using actual execution plans, estimated execution plans, and live query statistics.

In this article we look at how to build a SQL Server CLR function to use regex capabilities in SQL Server.

In this article we look at a TSQL function that will help you identify if an email address format is valid or not.

In this tip we look at how to track when SQL Server user defined functions were created, modified and last used.

In this tip we look at examples for creating SQL Server user defined functions for scalar-valued, table-valued and multi-statement table-valued functions.

In this article we look at the different types of SQL Server User Defined Functions and how they can be created and used.

In this tip we look at using different delimiters to split strings in SQL Server to show which ones work successful and which ones will cause errors.

In this tip we cover ways to improve scalar function performance in SQL Server. Functions are great for repeated use in queries, but there can be a performance impact, learn some ways to improve how functions perform.

In this tip, we look at a SQL Server function you can create and use to generate a CREATE TABLE script based on an input query to ensure you have the exact same data types and sizes.

In this tip we look at how SQL Server computed columns and scalar functions work together and the potential performance impact.

In this tip we look at how to dynamically handle conversions when trying to build TRY_CONVERT functionality in SQL Server 2008.

In this tip we look at how we can build our own TRY_CONVERT function for versions prior to SQL Server 2012.

In this tip we look at a user defined function that checks dynamic SQL code prior to execution.

Learn how to validate specific use cases for integer and decimal values in SQL Server.

This tip will recommend an option to improve SQL Server query performance when using a scalar UDF, by replacing it with a TVF.

Using scalar User Defined Function (UDF) generally causes performance issues when used on a large number of rows, because it is evaluated for each row returned by the query. This tip will describe some things you should know when working with queries tha

You want to create a SQL Server T-SQL function similar to Oracle's INITCAP PL/SQL function that returns a string with the first letter of each word in upper-case and all the other letters in lower-case.

Learn how to calculate a moving average in SQL Server with T-SQL code with a sample data set. Learn how to validate the results and visualize them as well.

Read this tip to learn about performance issues related to SQL Server user defined functions and how to find problematic UDFs.

One popular question I receive from either gamers or traders is how to measure a behavioral streak with SQL Server data? In some cases, these clients may not be tracking their measurements in a compatible manner, so this will also address the question, ho