SQL Server User Defined Function Example
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.
Functions
Learn SQL Server functions with practical tips, examples, and tutorials to improve querying and data analysis.
SQL Server User Defined Function Overview
In this article we look at the different types of SQL Server User Defined Functions and how they can be created and used.
SQL Server STRING SPLIT Limitations
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.
SQL Server FORMAT Dates, Numbers and SQL Server Agent Dates
In this tip we look at some other useful ways you can use the SQL Server FORMAT function in your daily work.
Fill In Missing Dates for SQL Server Query Output
In this tip we look at how to fill gaps in dates and times for SQL Server query output when no data exists for specific dates or times.
Simplify Date Period Calculations in SQL Server
Learn SQL Server date functions to get beginning and ending periods such as first day of the week, month, quarter, year, and dynamic end dates.
SQL Substring Examples for T-SQL, R and Python
In this tip we look at how to use substring functions or similar using T-SQL, R and Python when working with SQL Server.
SQL Server Date and Time Functions with Examples
Learn SQL Server date and time functions SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, CURRENT_TIMESTAMP, GETDATE(), DATENAME, DATEPART with examples.
Four ways to improve scalar function performance in SQL Server
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.
Using T-SQL to find events that overlap (or don’t) in SQL Server
Learn how to use T-SQL to find event dates that overlap or do not overlap based on some simple logic you can use in your queries.
Auto Generate Create Table Script Based on SQL Server Query
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.
Determine SQL Server Network Protocol Information using T-SQL and DMVs
In this tip we look at how we can use SQL Server DMVs to access information about SQL Server network protocol settings.
Create an Extended Date Dimension for a SQL Server Data Warehouse
Learn how to create a comprehensive data warehouse date dimension for richer data analysis to address business and performance needs.
Using FOR XML PATH and STRING_AGG() to denormalize SQL Server data
In this tip we look at how to take multiple rows of data and flatten the data into one row using FOR XML PATH and STRING_AGG.
Understanding and Using SQL Server sys.dm_exec_requests
In this tip we look at SQL Server sys.dm_exec_requests and various ways to use this to find active requests from connected users and applications.
T-SQL Starter Statistics Package for SQL Server
In this tip we cover several different T-SQL scripts to help you get started with statistics for SQL Server data.
Understanding and Using sys.dm_exec_sessions in SQL Server
In this tip we look at how we can use SQL Server DMV sys.dm_exec_sessions to see what sessions are doing in SQL Server.
Overview of SQL Server Table-Valued Functions sys.dm_exec_cursors and sys.dm_db_log_info
In this tip we take a look at you can use SQL Server table-valued functions sys.dm_exec_cursors and sys.dm_db_log_info to get more insight into SQL Server.
Computed Columns with Scalar Functions SQL Server Performance Issue
In this tip we look at how SQL Server computed columns and scalar functions work together and the potential performance impact.
Simulating TRY_CONVERT() in SQL Server 2008 – Part 2
In this tip we look at how to dynamically handle conversions when trying to build TRY_CONVERT functionality in SQL Server 2008.
Simulating TRY_CONVERT() 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.
SQL Server STRING_AGG and STRING_SPLIT functions
Read this tip to learn how to use the new SQL Server functions string_agg and string_split.
T-SQL: Capture Related Data and Return By Aggregates
In this tip we cover a T-SQL process to collect right and wrong answers to questions to help use these data points for better decision making.
SQL Server DateTime Best Practices
Learn about the common SQL Server date mistakes such as regional dates, shorthand, BETWEEN and more.