SQL Server Functions - User Defined UDF Tips
Concatentation
Data
Data Validation
- SQL Server function to validate Social Security Numbers SSN
- SQL Server Regular Expressions for Data Validation and Cleanup
- Validate Integer and Decimal Values in SQL Server
Email
File System
- Extending File System Operations in SQL Server Using CLR
- How to execute a DOS command when xp_cmdshell is disabled in SQL Server
- Read and Write Binary Files with the SQL Server CLR
- Use the SQL Server CLR to Read and Write Text Files
- Writing to an operating system file using the SQL Server SQLCLR
Financial
Numbers
- Implementing Luhn's Algorithm in T-SQL to validate credit card numbers
- SQL Server random numerics data generation using CLR
- SQL Server T-SQL Code to Calculate a Moving Average
- SQL Server user defined function to convert MSDB integer value to time value
Overview
- Introduction to SQL Server CLR table valued functions
- SQL Server User Defined Function Overview
- Understand the Performance Behavior of SQL Server Scalar User Defined Functions
Performance
- Computed Columns with Scalar Functions SQL Server Performance Issue
- Four ways to improve scalar function performance in SQL Server
- How to find UDFs causing SQL Server performance issues
- Refactor SQL Server scalar UDF to inline TVF to improve performance
Random Data
- Create Your Own RANDBETWEEN Function in T-SQL
- Video on how to create your own RANDBETWEEN function for SQL Server
Search
Sorting
Storage
Strings
- Create a SQL Server InitCap Function
- Finding a string value in a SQL Server table
- Parsing a URL with SQL Server Functions
- Remove HTML tags from strings using the SQL Server CLR
- SQL Server CLR and SQL split functions to parse a delimited string
- SQL Server function to determine if all characters are capitalized
- SQL Server STRING SPLIT Limitations
- SQL Server UDF to pad a string
System
Tables
Tools
