SQL Server Functions - System Tips
Aggregate
Calculations
Comparison
Concatentation
- CONCAT and CONCAT_WS function in SQL Server
- Concatenate SQL Server Columns into a String with CONCAT()
- Using SQL Server Concatenation Efficiently
Conversions
- Concatenation of Different SQL Server Data Types
- New Data Type Conversion Functions in SQL Server 2012
Date Range
Email
Logical
Meta Data
Monitoring
- SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
- Understanding and Using SQL Server sys.dm_exec_requests
Network
Numbers
Overview
- Overview of SQL Server Table-Valued Functions sys.dm_exec_cursors and sys.dm_db_log_info
- Understanding and Using sys.dm_exec_sessions in SQL Server
Performance
Random Data
- Different ways to get random data for SQL Server data sampling
- Generate Unique Random Number in SQL Server
- Randomly Retrieve SQL Server Records
- Retrieving random data from SQL Server with TABLESAMPLE
Ranking
- Calculate the Statistical Mode in SQL Server using T-SQL
- Forgotten SQL Server Functions - VARP, SOUNDEX and NTILE
- Percent_Rank and Cume_Dist functions in SQL Server 2012
- SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE
- SQL Server 2012 Analytical Functions - Percentile_Cont and Percentile_Disc
- SQL Server 2012 Functions - First_Value and Last_Value
- SQL Server Lead and Lag Functions
- SQL Server Ranking Functions Row_Number and Rank
Result Set
Server
Statistics
Strings
- Dealing with the single-character delimiter in SQL Server's STRING_SPLIT function
- Deciding between COALESCE and ISNULL in SQL Server
- Name Parsing for Result Sets with Different Name Formats
- Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL
- Name Parsing with SQL Server Functions and T-SQL Programming
- New FORMAT and CONCAT Functions in SQL Server 2012
- Parsing string data with the new SQL Server 2016 STRING_SPLIT function
- Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions
- Solve old problems with SQL Server’s new STRING_AGG and STRING_SPLIT functions
- SQL Server 2016 STRING_SPLIT Function
- SQL Server REPLACE
- SQL Server Split String Replacement Code with STRING_SPLIT
- SQL Server Substring Function Example with T-SQL, R and Python
- SQL Server Text Data Manipulation
- The Many Uses of Coalesce in SQL Server
- Using FOR XML PATH and STRING_AGG() to denormalize SQL Server data
System
- CHECKSUM Functions in SQL Server 2005
- SQL Server 2008 Functions for Tables, Views, Indexes, Columns, Stored Procedures
- Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name
- Using the SQL Server APP_NAME function to control stored procedure execution
Window Functions