Functions System

In this tip we look at how we can use SQL Server DMVs to access information about SQL Server network protocol settings.

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.

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.

In this tip we cover several different T-SQL scripts to help you get started with statistics for SQL Server data.

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.

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.

Read this tip to learn how to use the new SQL Server functions string_agg and string_split.

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.

In this tip we look at eight new properties that can be returned using the SQL Server SERVERPROPERTY function.

SQL Server 2016 introduced a new built-in function STRING_SPLIT() but it only supports a single-character delimiter. Read this tip to learn how to overcome this issue.

Learn how to use the SQL Server 2016 STRING_SPLIT function as well as limitations and performance considerations.

This tip will explain the differences between the following COUNT function varieties: COUNT(*) vs. COUNT(1) vs. COUNT(column_name) to determine if there is a performance difference.

How do I find some of the basic descriptive statistics of a column such as the maximum, minimum, and average values in SQL Server with T-SQL code? Can you provide some examples?

I have a dataset where I need to find the minimum and maximum values in a SQL Server table. In the case where multiple rows contain the same minimum or maximum value I only want to select the first occurrence. Read this tip to learn how.

I'm tracking weekly quantities of product sales and I would like to create a normalized score of product sales each week from 1 to 100. Read this tip to learn how to do this with T-SQL.

What is the best way to find the number of rows in a SQL Server table? What are various options in SQL Server to get a count of rows? Can you provide any examples?

In this tip we will look at the new function string_split introduced in SQL Server 2016.

Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Se

Analytics in the Health Care industry requires locating previous visits or claims that indicate if a patient/member is being readmitted to a hospital or rehab facility. Basic T-SQL is very difficult to use in order compute these rates when not using tempo

Metadata is invaluable when dealing with SQL Server and in this tip we look at how to bring SQL Server metadata into a Python based Program.

My company receives name strings in a variety of different formats. One of our partners sends us name strings that can contain names for either one or two persons. In addition, the same partner also sends us name strings in a variety of different formats.

My company receives sets of names in a variety of different formats from business partners. Are there any special tips for processing a whole set of name source strings instead of parsing them individually? Furthermore, what are some tips for parsing name

My company receives names in a variety of different formats from business partners. The formatting for names varies substantially across business partners. However, the names need to be parsed into one consistent format to help with tracking details assoc

You are looking to retrieve a random sample from a query result set. In this tip we look at different approaches using T-SQL.