Functions

Learn SQL Server functions with practical tips, examples, and tutorials to improve querying and data analysis.

Title Author Date
New SQL Regex Functions in SQL Server 2025 and SSMS Scott Murray2026-07-16
SQL Date Format Examples using CONVERT Function MSSQL Tips2026-07-15
Using T-SQL to find events that overlap (or don’t) in SQL Server Aaron Bertrand2026-07-14
Time Series Data Mining Example with T-SQL when Adding New Data Rick Dobson2026-07-10
Solve Maximum Flow Problem with Ford-Fulkerson Algorithm Sebastiao Pereira2026-07-08
Format SQL Server Dates with FORMAT Function Daniel Calbimonte2026-07-06
SQL Server Window Functions Examples Koen Verbeeck2026-07-06
SQL Server Window Functions LEAD and LAG Koen Verbeeck2026-07-06
SQL Server Window Functions Performance Improvement Koen Verbeeck2026-07-06
SQL Server T-SQL Window Functions Tutorial Koen Verbeeck2026-07-06
Select SQL Server Data Between Two Dates Hadi Fadlallah2026-06-29
Parsing a URL with SQL Server Functions Jeremy Kadlec2026-06-28
Parameter List for all SQL Server Stored Procedures and Functions Atif Shehzad2026-06-27
SQL Server function to convert integer date to datetime format Tim Ford2026-06-27
SQL in 30 – Aggregate Functions MSSQL Tips2026-06-27
Crosstab queries using PIVOT in SQL Server Greg Robidoux2026-06-25
SQL Server Char Function and Reference Guide Joe Gavin2026-06-24
Using SQL Server RAND Function Deep Dive Nai Biao Zhou2026-06-24
SQL Coalesce Function Examples and Use Cases Rajendra Gupta2026-06-24
SQL Rand Function to Perform Monte Carlo Simulation Rick Dobson2026-06-24
Newton Cotes Formula for Numerical Integration in SQL Server Sebastiao Pereira2026-06-22
Add and Subtract Dates using DATEADD in SQL Server Tim Cullen2026-06-19
Graph Theory – Shortest Path Algorithms Sebastiao Pereira2026-06-11
SQL Server Functions – VARP, SOUNDEX and NTILE Derek Colley2026-06-09
Convert a String to JSON with SQL Server Queries Joe Gavin2026-06-03
SQL Format Currency Code Examples Daniel Calbimonte2026-05-27
SQL Server Current Date Jim Evans2026-05-27
Graham Scan Algorithm in SQL Server Sebastiao Pereira2026-05-18
Split Delimited String into Columns in SQL Server Aubrey Love2026-05-14
Using REGEXP_COUNT to Count Strings in SQL Server 2025 Jared Westover2026-05-13
Creating a date dimension or calendar table in SQL Server Aaron Bertrand2026-05-13
Calculate Rolling Average with SQL DATE_BUCKET Function Koen Verbeeck2026-05-10
SQL Server 2025 REGEXP_MATCHES Function to Extract Multiple Substrings Koen Verbeeck2026-05-09
Date Truncation with DATETRUNC() function in SQL Server Rajendra Gupta2026-05-06
REGEXP_LIKE Function in SQL Server 2025 Koen Verbeeck2026-05-06
Fuzzy String Matching Algorithms in SQL Server Sebastiao Pereira2026-05-04
SQL PIVOT and SQL UNPIVOT Examples to Transform Data Daniel Calbimonte2026-05-03
SOFTMAX Function in SQL Server Sebastiao Pereira2026-04-09
SQL String Functions for Data Transformations Muhammad Hassan Arshad2026-03-11
How NTILE Handles Uneven Row Distribution in SQL Jared Westover2026-03-07
Random Number Generator in SQL using Marsaglia Polar Sebastiao Pereira2026-03-06
Random Exponential Gaussian Numbers in SQL using Ziggurat Algorithm Sebastiao Pereira2026-03-06
When to use DENSE_RANK instead of SQL RANK Jared Westover2026-02-12
SQL Concatenate String using Double Pipe (||) Operator in SQL Server 2025 Rajendra Gupta2026-02-06
OPTICS Clustering Algorithm in SQL Server Sebastiao Pereira2026-02-04
Regex String Split using SQL Server 2025 REGEXP_SPLIT_TO_TABLE Koen Verbeeck2026-01-27
Using REGEXP_LIKE in SQL Server 2025 Jared Westover2026-01-12
Random Numbers Generator for Poker Simulator in SQL Server Sebastiao Pereira2026-01-05
Powerful Text Extraction with REGEXP_SUBSTR in SQL Server 2025 Koen Verbeeck2025-12-11
Generating Shape Bound Random Points in SQL Server Sebastiao Pereira2025-12-05
Controlling SQL Window Functions with Framing Jared Westover2025-12-01
Recursive EMA Logic in SQL Server Using Wide-Format Time Series Data Rick Dobson2025-11-21
Replace Text using RegEx with SQL Server 2025 REGEXP_REPLACE Koen Verbeeck2025-11-20
Ziggurat Algorithm for Normal Random Gaussian Numbers in SQL Server Sebastiao Pereira2025-11-07
SQL Format Number with CAST, CONVERT and more Daniel Calbimonte2025-10-31
Random Gaussian Numbers in SQL using Box-Muller Transform Sebastiao Pereira2025-10-15
Extract Text using Regular Expressions with SQL Server 2025 Function REGEXP_INSTR Koen Verbeeck2025-10-13
Storing and Reporting on Genealogy Data in SQL Server Sebastiao Pereira2025-10-06
SQL Partition By Examples for Aggregating Data Burt King2025-10-01
SQL Concat Operator and UNISTR Function in Azure Koen Verbeeck2025-09-22
DBSCAN Algorithm in SQL Server Sebastiao Pereira2025-09-19
SQL Server 2025 REGEXP_COUNT Function to Count Occurrences in Text Koen Verbeeck2025-09-08
Script to Create a SQL Time Dimension Table Koen Verbeeck2025-06-25
Graph Minimum Spanning Tree (MST) in SQL Server Sebastiao Pereira2025-06-23
Rand() and Newid() for SQL Random Numbers Rick Dobson2025-06-11
Simplify SQL Date Calculations – First, Last, Nth Day of the Month Aaron Bertrand2025-06-10
SQL Convert INT to String Daniel Calbimonte2025-05-28
Calculate Difference Between Two SQL Dates as hh:mi:ss or hh:mi Sean Lee2025-05-27
SQL Convert Date to YYYYMMDD Jim Evans2025-05-27
SQL Rank Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE Jared Westover2025-05-26
SQL Server System Functions for Server and Database Properties Arshad Ali2025-05-21
Video on how to create your own RANDBETWEEN function for SQL Server Dallas Snider2025-05-21
SQL CURRENT_TIMESTAMP Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEADD Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEDIFF Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEFROMPARTS Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATENAME Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEPART Function Use and Examples Daniel Calbimonte2025-04-28
SQL DAY Function Use and Examples Daniel Calbimonte2025-04-28
SQL GETDATE Function Use and Examples Daniel Calbimonte2025-04-28
SQL GETUTCDATE Function Use and Examples Daniel Calbimonte2025-04-28
SQL ISDATE Function Use and Examples Daniel Calbimonte2025-04-28
SQL MONTH Function Use and Examples Daniel Calbimonte2025-04-28
SQL SYSDATETIME Function Use and Examples Daniel Calbimonte2025-04-28
SQL YEAR Function Use and Examples Daniel Calbimonte2025-04-28
SQL Server Date and Time Data Type Comparison Aaron Bertrand2025-04-27
Recommended SQL Server Date Formats Aaron Bertrand2025-04-27
SQL Server Between Dates Issue Aaron Bertrand2025-04-27
SQL Server Date Time Shorthand and Other Tricks Aaron Bertrand2025-04-27
SQL CONCAT Function Use and Examples Daniel Calbimonte2025-04-27
SQL CONCAT_WS Function Use and Examples Daniel Calbimonte2025-04-27
SQL DATALENGTH Function Use and Examples Daniel Calbimonte2025-04-27
SQL DIFFERENCE Function Use and Examples Daniel Calbimonte2025-04-27
SQL FORMAT Function Use and Examples Daniel Calbimonte2025-04-27
SQL LEFT Function Use and Examples Daniel Calbimonte2025-04-27
SQL LEN Function Use and Examples Daniel Calbimonte2025-04-27
SQL LOWER Function Use and Examples Daniel Calbimonte2025-04-27
SQL LTRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL NCHAR Function Use and Examples Daniel Calbimonte2025-04-27
SQL PATINDEX Function Use and Examples Daniel Calbimonte2025-04-27
SQL QUOTENAME Function Use and Examples Daniel Calbimonte2025-04-27
SQL REPLICATE Function Use and Examples Daniel Calbimonte2025-04-27
SQL REVERSE Function Use and Examples Daniel Calbimonte2025-04-27
SQL RIGHT Function Use and Examples Daniel Calbimonte2025-04-27
SQL RTRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL SOUNDEX Function Use and Examples Daniel Calbimonte2025-04-27
SQL SPACE Function Use and Examples Daniel Calbimonte2025-04-27
SQL STR Function Use and Examples Daniel Calbimonte2025-04-27
SQL STRING_ESCAPE Function Use and Examples Daniel Calbimonte2025-04-27
SQL STUFF Function Use and Examples Daniel Calbimonte2025-04-27
SQL SUBSTRING Function Use and Examples Daniel Calbimonte2025-04-27
SQL TRANSLATE Function Use and Examples Daniel Calbimonte2025-04-27
SQL TRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL UNICODE Function Use and Examples Daniel Calbimonte2025-04-27
SQL UPPER Function Use and Examples Daniel Calbimonte2025-04-27
Evaluating the Randomness of SQL Server Random Number Functions Rick Dobson2025-04-24
SQL REPLACE Function Use and Examples Daniel Calbimonte2025-04-24
SQL ASCII Function Use and Examples Greg Robidoux2025-04-23
SQL CHAR Function Use and Examples Greg Robidoux2025-04-23
SQL CHARINDEX Function Use and Examples Greg Robidoux2025-04-23
SQL STRING_AGG Function Use and Examples Daniel Calbimonte2025-04-23
SQL Matrix Calculator and Operations Toolkit Sebastiao Pereira2025-04-09
Calculating Matrix Inverse in SQL Server Sebastiao Pereira2025-04-02
Gauss-Seidel Method SQL Function to Solve Linear Equations Sebastiao Pereira2025-03-10
Lagrange Interpolation Function for SQL Server Sebastiao Pereira2025-03-04
Basic Regex Emulator for SQL Server Sebastiao Pereira2025-02-25
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG Koen Verbeeck2025-02-24
SQL ROUND – Rounding versus Truncating Rick Dobson2025-02-12
Regression Analysis in SQL Sebastiao Pereira2025-02-06
Calculate Distance Between Two Points with SQL Sebastiao Pereira2025-01-27
Concatenate SQL Server Column Values with CONCAT() Chad Churchwell2025-01-13
How to Find Outliers in SQL Server Sebastiao Pereira2025-01-10
SQL Server Date and Time Functions with Examples Joe Gavin2024-12-31
Compare SQL Round to Bankers Rounding for Millions of Decimal Values Rick Dobson2024-12-24
Tackling the Gaps and Islands Problem with T-SQL Window Functions MSSQL Tips2024-12-19
Calculate a Moving Average with T-SQL Windowing Functions Jared Westover2024-11-13
SQL Combine Multiple Columns – UNPIVOT, UNION ALL vs CROSS APPLY Jared Westover2024-09-30
SQL Server Functions for Tables, Views, Indexes, Columns, and more Arshad Ali2024-08-13
SQL ROUND Function vs. Bankers Rounding with T-SQL Rick Dobson2024-07-29
Standardize Text with Multi Search and Replace Function in SQL Server Greg Robidoux2024-06-21
Generating Uniform, Normal, or Lognormal Random Numbers in SQL Server Rick Dobson2024-05-31
SQL Convert Examples for Dates, Integers, Strings and more Joe Gavin2024-05-28
Manipulate Strings in SQL Server with REPLACE, TRIM, STUFF, CHARINDEX Jared Westover2024-03-05
Unpivot Data with SQL Server Queries using CROSS APPLY Aaron Bertrand2023-11-08
SQL Server Rounding to the Nearest Penny with T-SQL Rick Dobson2023-10-10
SQL WHILE Loop to Process Time Series Data Rick Dobson2023-09-25
SQL Pivot and Unpivot Data using T-SQL Code Jared Westover2023-09-22
SQL Rounding Functions with ROUND, CEILING, FLOOR, Bankers Rounding Rick Dobson2023-09-20
NTILE SQL Function to Group and Rank Datasets Harris Amjad2023-07-05
SQL Round Function Examples Rajendra Gupta2023-06-14
SQL Server JSON_PATH_EXISTS Function Daniel Calbimonte2023-06-08
SQL Server ISJSON for valid Value, Array or Object JSON format Daniel Calbimonte2023-05-25
SQL SUBSTRING Code Examples and Usage Rajendra Gupta2023-05-10
SQL SUM Function for Aggregating and Summarizing Totals John Miner2023-04-20
Replace Text in SQL Server Strings using REPLACE and TRANSLATE Jared Westover2023-04-19
Build a Time Slicer by Week using DAX Kenneth A. Omorodion2023-04-12
Learn about SQL Date Data Types – Date, DateTime, DateTime2, Time Hadi Fadlallah2023-03-15
TRY_PARSE Functionality for SQL Server 2008 to Determine Valid Dates Aaron Bertrand2023-03-09
SQL Calendar Table Simplified using a Table and a View Aaron Bertrand2023-02-22
SQL STUFF, SQL REPLACE and SQL WRITE Similarities and Differences Aubrey Love2023-02-17
Troubleshoot Performance with User Defined Functions in SQL Server Eric Blinn2023-02-13
SQL Server ROW_NUMBER Ranking Function that Returns a Row Rank Value Jared Westover2023-02-08
Generate Events Calendar in HTML with SQL Server and CSS Aaron Bertrand2023-02-07
How to get Time from a RowVersion value with T-SQL Code Eric Blinn2022-12-02
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server Eric Blinn2022-11-22
SELECT COUNT FROM SQL Server Examples and Statistics Jared Westover2022-11-16
SQL Server Logarithmic Functions LOG() and LOG10() for Data Outliers Harris Amjad2022-10-20
Time Series Data Models in SQL Server and Excel to Visualize Data Rick Dobson2022-10-07
Deciding between COALESCE and ISNULL in SQL Server Aaron Bertrand2022-10-03
The Many Uses of Coalesce in SQL Server Ken Simmons2022-09-30
SQL Server OBJECTPROPERTY Function Examples Manvendra Singh2022-09-30
DENSE_RANK SQL Server Function for Nth Highest Record Harris Amjad2022-09-28
SQL CONVERT, CAST, TRY_CAST, TRY_CONVERT and TRY_PARSE Examples Jared Westover2022-08-30
Metadata Functions in SQL Server SERVERPROPERTY, DB_NAME, OBJECT_ID Manvendra Singh2022-08-19
SQL Concatenate Strings Example Daniel Calbimonte2022-08-12
Delay SQL Code Execution with SQL WAITFOR Aubrey Love2022-08-08
Create an Extended Date Dimension for a SQL Server Data Warehouse Dinesh Asanka2022-08-04
SQL COUNT and SQL COUNT_BIG Functions Manvendra Singh2022-07-13
Random Date Generator in SQL Server Jared Westover2022-07-12
SQL Server Configuration Functions Manvendra Singh2022-07-06
SQL Average Function to Calculate Average of a set of SQL Server Rows Manvendra Singh2022-06-22
Candlestick Charts for Time Series Data in SQL Server and Python Rick Dobson2022-05-24
SQL MAX Examples and Use Cases Manvendra Singh2022-05-05
Build Heikin Ashi Charts in Excel based on Financial Time Series Data Rick Dobson2022-04-29
DATEADD SQL Function to Add and Subtract Dates and Times Manvendra Singh2022-04-26
SQL DATEDIFF and DATEDIFF_BIG Functions with Sample Code Manvendra Singh2022-04-11
Compare Time Series Datasets with T-SQL Code Rick Dobson2022-03-30
SQL Server datetimeoffset for Time Zones Eric Blinn2022-03-14
Create Candlestick and Heikin Ashi Charts for Time Series Data Rick Dobson2022-03-10
SQL PIVOT and GROUPING SETS for Advanced Reporting Aaron Bertrand2022-03-07
SQL Date Format Comparison for Computed Column and Materialized Column Aaron Bertrand2022-03-01
Migrate Time Series Data to SQL Server from Yahoo Finance Stooq.com Rick Dobson2022-02-24
Learn WHILE and GOTO Loops with T-SQL for Time Series Data Rick Dobson2022-02-17
SQL Date Format Comparison – SQL FORMAT vs. SQL CONVERT Aaron Bertrand2022-02-16
Learn SQL CAST Function with Examples and Alternatives Koen Verbeeck2022-02-01
SQL Substring Examples for T-SQL, R and Python Siddharth Mehta2022-01-24
SQL REPLACE Overview and Examples Garry Bargsley2022-01-24
Learn SQL SUBSTRING Function Koen Verbeeck2022-01-24
Time Series Data in SQL Server to Model and Log Trends Rick Dobson2022-01-21
SQL Convert Function In Depth Ben Snaidero2022-01-20
Python Regex Explained with Examples Nai Biao Zhou2021-12-23
Relative Strength Index using Time Series Data in SQL Server Rick Dobson2021-12-14
Azure SQL Database GREATEST and LEAST functions Aaron Bertrand2021-12-08
Find MAX value from multiple columns in a SQL Server table Sergey Gigoyan2021-12-08
SQL Aggregate Functions Code Samples Koen Verbeeck2021-12-03
STRING_SPLIT Function in Azure SQL Database for Ordinal Position Aaron Bertrand2021-11-11
Performance Comparison of Ordered String Splitting in SQL Server Aaron Bertrand2021-11-08
SQL Server FORMAT Dates, Numbers and SQL Server Agent Dates Jeffrey Yao2021-10-28
SQL COUNT Code Examples Aubrey Love2021-10-25
Compare SQL Performance for Splitting Comma Separated Strings Aaron Bertrand2021-10-22
Time Series Analysis in SQL Creation and Comparison Rick Dobson2021-10-07
SQL Concatenate Examples Koen Verbeeck2021-10-05
Examples for SQL CAST and SQL CONVERT Functions Koen Verbeeck2021-09-16
SQL Server Rounding Functions – Round, Ceiling and Floor Jeremy Kadlec2021-07-20
Create a Calendar Table in SQL Server to Optimize Scheduling Problems Aaron Bertrand2021-06-16
SQL CAST Function for Data Type Conversions Aubrey Love2021-05-25
SQL DATE Functions Jim Evans2021-05-18
SQL Server SERVERPROPERTY() Use Cases Manvendra Singh2021-04-30
Calendar Table in SQL Server to Identify Date Gaps and Islands Aaron Bertrand2021-04-28
SQL Server Calendar Table Example Aaron Bertrand2021-04-22
COALESCE SQL Function Jim Evans2021-03-22
SQL ISNULL Function Examples Ben Snaidero2021-03-18
SQL Server Date Format YYYY-MM-DD Considerations Aaron Bertrand2021-03-04
CONCAT SQL Function in SQL Server Rajendra Gupta2021-02-22
SQL Window Functions in SQL Server Eric Blinn2021-02-16
Randomly Retrieve SQL Server Records Greg Robidoux2020-09-02
Retrieving random data from SQL Server with TABLESAMPLE Greg Robidoux2020-09-02
SQL Server Regex CLR Function Ian Fogelman2020-08-20
Valid Email Address Check with TSQL Matteo Lorini2020-08-18
A way to improve STRING_SPLIT in SQL Server – and you can help Aaron Bertrand2020-08-11
SQL Server RegEx Capabilities Using Python Ian Fogelman2020-07-30
DATEDIFF SQL Server Function Jim Evans2020-07-16
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table Koen Verbeeck2020-07-15
Analyze Relationship Between Two Time Series in SQL Server Rick Dobson2020-06-25
SQL Server Split String Replacement Code with STRING_SPLIT Aaron Bertrand2020-06-01
Generate Unique Random Number in SQL Server Rick Dobson2020-04-01
Weighted vs Simple Moving Average with SQL Server T-SQL Code Rick Dobson2020-03-16
Selecting a Simple Random Sample from a SQL Server Database Nai Biao Zhou2020-03-12
How to Compute Simple Moving Averages with Time Series Data in SQL Server Rick Dobson2020-03-03
Time Series Data Fact and Dimension Tables for SQL Server Rick Dobson2020-02-14
Collecting Time Series Data for Stock Market with SQL Server Rick Dobson2020-02-10
Load Time Series Data with SQL Server Rick Dobson2020-01-24
SQL Server Dynamic PIVOT Query Eli Leiba2019-12-04
Get SQL Server UDF Create, Modified, Last Execution Date and Code Rick Dobson2019-11-20
Update only Year, Month or Day in a SQL Server Date Atul Gaikwad2019-11-14
SQL Server User Defined Function Example Rick Dobson2019-11-01
SQL Server User Defined Function Overview Rick Dobson2019-10-08
SQL Server STRING SPLIT Limitations Aaron Bertrand2019-09-03
Fill In Missing Dates for SQL Server Query Output Jim Evans2019-07-12
Simplify Date Period Calculations in SQL Server Aaron Bertrand2019-06-27
Get SQL Server Date and Time Parts with DATEPART and DATENAME Tim Cullen2019-05-24
Four ways to improve scalar function performance in SQL Server Aaron Bertrand2019-01-11
Auto Generate Create Table Script Based on SQL Server Query Daniel Farina2018-10-05
SQL Server Function to Generate Random Numbers Eli Leiba2018-08-07
Determine SQL Server Network Protocol Information using T-SQL and DMVs Eduardo Pivaral2018-08-06
Using FOR XML PATH and STRING_AGG() to denormalize SQL Server data Aaron Bertrand2018-06-22
Understanding and Using SQL Server sys.dm_exec_requests K. Brian Kelley2018-06-20
T-SQL Starter Statistics Package for SQL Server Rick Dobson2018-06-07
Understanding and Using sys.dm_exec_sessions in SQL Server K. Brian Kelley2018-06-06
SQL Server Window Function Syntax Koen Verbeeck2018-05-31
SQL Server Window Aggregate Functions SUM, MIN, MAX and AVG Koen Verbeeck2018-05-31
SQL Server Window Functions ROW_NUMBER Koen Verbeeck2018-05-31
SQL Server Window Functions RANK, DENSE_RANK and NTILE Koen Verbeeck2018-05-31
SQL Statistical Window Functions PERCENTILE_DISC and PERCENTILE_CONT Koen Verbeeck2018-05-31
SQL Server Window Functions Gaps and Islands Problem Koen Verbeeck2018-05-31
CLR String Sort Function in SQL Server Greg Robidoux2018-05-29
Overview of SQL Server Table-Valued Functions sys.dm_exec_cursors and sys.dm_db_log_info Jayendra Viswanathan2018-05-02
Computed Columns with Scalar Functions SQL Server Performance Issue Ahmad Yaseen2018-04-27
Simulating TRY_CONVERT() in SQL Server 2008 – Part 2 Aaron Bertrand2018-04-25
Simulating TRY_CONVERT() in SQL Server 2008 Aaron Bertrand2018-04-02
Mining Stock Price Time Series with MACD in SQL Server Rick Dobson2018-02-06
Mining Time Series with Exponential Moving Averages in SQL Server Rick Dobson2018-01-25
SQL Server STRING_AGG and STRING_SPLIT functions Aaron Bertrand2018-01-19
Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server Rick Dobson2017-12-27
SQL Server DateTime Best Practices Aaron Bertrand2017-11-15
Additional SERVERPROPERTY properties in SQL Server Ahmad Yaseen2017-08-16
SQL Server function to check dynamic SQL syntax Eli Leiba2017-08-02
Dealing with the single-character delimiter in SQL Server’s STRING_SPLIT function Aaron Bertrand2017-06-22
SQL Server 2016 STRING_SPLIT Function Ahmad Yaseen2017-05-17
Validate Integer and Decimal Values in SQL Server Bhavesh Patel2017-05-11
Refactor SQL Server scalar UDF to inline TVF to improve performance Simon Liew2017-03-22
Understand the Performance Behavior of SQL Server Scalar User Defined Functions Simon Liew2017-02-09
Create a SQL Server InitCap Function Eli Leiba2016-09-26
SQL Server COUNT() Function Performance Comparison Simon Liew2016-09-19
Max, Min, and Avg SQL Server Functions Tim Wiseman2016-08-23
Select min and max values along with other SQL Server columns using T-SQL Dallas Snider2016-08-22
Count of rows with the SQL Server COUNT Function Tim Wiseman2016-07-07
Parsing string data with the new SQL Server 2016 STRING_SPLIT function John Miner2016-06-27
SQL Server T-SQL Code to Calculate a Moving Average Dallas Snider2016-03-08
Removing Duplicates from Strings in SQL Server Aaron Bertrand2016-01-14
How to find UDFs causing SQL Server performance issues Fikrat Azizov2015-12-07
Build a cheat sheet for SQL Server date and time formats Aaron Bertrand2015-10-13
Converting and Using Text Dates as SQL Server Dates Rick Dobson2015-05-26
How To Calculate Behavioral Streaks in SQL Server Data Tim Smith2015-05-04
Python and Regex for SQL Server ETL with Non-Standard Text Files Tim Wiseman2015-04-10
A More Versatile SQL Server Random Number Function Dallas Snider2015-03-23
Calculate the Statistical Mode in SQL Server using T-SQL Koen Verbeeck2015-03-10
SQL Server Random Sorted Result Set Dallas Snider2015-02-26
SQL Server Date Time Calculation Examples Jeffrey Yao2015-02-13
SQL Servers Lag and Lead Functions to Help Identify Date Differences Thomas LeBlanc2015-01-19
Getting SQL Server Metadata With Python Tim Wiseman2015-01-16
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL Rick Dobson2014-09-16
Implementing Luhn’s Algorithm in T-SQL to validate credit card numbers Derek Colley2014-08-27
Create Your Own RANDBETWEEN Function in T-SQL Dallas Snider2014-08-04
Name Parsing for Result Sets with Different Name Formats Rick Dobson2014-07-15
Name Parsing with SQL Server Functions and T-SQL Programming Rick Dobson2014-05-22
Handle conversion between time zones in SQL Server – part 3 Aaron Bertrand2014-04-01
Handle conversion between time zones in SQL Server – part 2 Aaron Bertrand2014-03-10
Handle conversion between time zones in SQL Server – part 1 Aaron Bertrand2014-03-04
Different ways to get random data for SQL Server data sampling Derek Colley2014-01-29
Generating Random Numbers in SQL Server Without Collisions Aaron Bertrand2013-09-17
Performance Comparison of SQL Server PARSE, CAST, CONVERT Ben Snaidero2013-08-21
Concatenation of Different SQL Server Data Types Chad Churchwell2013-07-29
Use SQL Server’s UNPIVOT operator to dynamically normalize output Aaron Bertrand2013-07-24
Use SQL Server’s UNPIVOT operator to help normalize output Aaron Bertrand2013-07-12
SQL Server APP_NAME function to control stored procedure execution Siddharth Mehta2013-03-11
SQL Server CLR and SQL split functions to parse a delimited string Greg Robidoux2013-01-14
Restore SQL Server Databases using DateTime functions Brady Upton2012-12-21
SQL Server Function to return a range of dates Albert Hetzel2012-10-25
Using SQL Server Concatenation Efficiently Sherlee Dizon2012-10-18
Script to create dynamic PIVOT queries in SQL Server Aaron Bertrand2012-10-16
Percent_Rank and Cume_Dist functions in SQL Server 2012 Rajendra Gupta2012-06-12
SQL Server 2012 Analytical Functions – Percentile_Cont and Percentile_Disc Rajendra Gupta2012-06-01
Work around for calculating age using the SQL Server DateDiff function Rick Dobson2012-05-09
SQL Server Lead and Lag Functions Rajendra Gupta2012-04-16
SQL Server 2012 Functions – First_Value and Last_Value Rajendra Gupta2012-03-12
FORMAT and CONCAT Functions in SQL Server Ashish Kumar Mehta2012-01-24
Introduction to SQL Server CLR table valued functions Diana Moldovan2012-01-16
New Date and Time Functions in SQL Server 2012 Ashish Kumar Mehta2012-01-09
New Logical Functions in SQL Server 2012 (IIF and CHOOSE) Ashish Kumar Mehta2011-12-28
New Data Type Conversion Functions in SQL Server 2012 Ashish Kumar Mehta2011-12-23
SQL Server stored procedure to generate random passwords Brent Shaub2011-11-14
Script to calculate the Median value for SQL Server data Eli Leiba2011-10-31
SQL Server DateDiff Example Tim Cullen2011-10-10
Remove HTML tags from strings using the SQL Server CLR Diana Moldovan2011-06-23
Converting UTC to local time with SQL Server CLR Diana Moldovan2011-04-07
Mimic timestamp behavior of other database platforms to store last modified date Murali Krishnan2011-03-10
SQL Server random numerics data generation using CLR Alex Tocitu2011-03-09
Convert SQL Server DateTime Data Type to DateTimeOffset Data Type John Sterrett2011-02-23
SQL Server Regular Expressions for Data Validation and Cleanup Alex Tocitu2011-02-09
SQL Server function to validate Social Security Numbers SSN Vamsi Bogullu2011-01-10
Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server Tim Cullen2010-11-16
Execute DOS command when xp_cmdshell is disabled in SQL Server Andy Novick2010-08-11
SQLCLR function to return free space for all drives on a server Andy Novick2010-04-16
SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE Arshad Ali2010-03-01
SQL Server Ranking Functions Row_Number and Rank Arshad Ali2010-02-17
SQL Server Date function that determines date range based on weekday Tim Ford2009-06-10
Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name Tim Ford2009-06-04
SQL Server function to convert MSDB integer value to time value Tim Ford2009-05-05
SQL Server UDF to pad a string Tim Ford2009-04-27
SQL Server function to validate email addresses Andy Novick2009-01-23
Finding a string value in a SQL Server table Tim Ford2008-12-29
SQL Server 2008 Date and Time Data Types Tim Ford2008-10-30
TSQL Function to Determine Holidays in SQL Server Tim Cullen2008-07-10
Dynamically controlling the number of rows affected by a SQL Server query Greg Robidoux2008-07-08
Daylight Savings Time Functions in SQL Server Tim Cullen2007-11-13
SQL Server function to determine if all characters are capitalized Tim Ford2007-11-07
SQL Server T-SQL Aggregate Functions Jeremy Kadlec2007-04-12
Getting a SQL Server RowCount Without doing a Table Scan Andy Novick2006-08-21
SQL Server Text Data Manipulation Greg Robidoux2006-07-25
CHECKSUM Functions in SQL Server 2005 Jeremy Kadlec2006-07-19