The Many Uses of Coalesce in SQL Server
SQL Server 2012 Analytical Functions – Percentile_Cont and Percentile_Disc
Using the OBJECT_SCHEMA_NAME function to return the SQL Server schema name
SQL Server 2012 Functions – Lead and Lag
SQL Server 2012 Functions – First_Value and Last_Value
New FORMAT and CONCAT Functions in SQL Server 2012
Copyright (c) 2006-2018Edgewood Solutions, LLCAll rights reserved
Solve old problems with SQL Servers new STRING_AGG and STRING_SPLIT functions
SQL Server 2005 and 2008 Ranking Functions Row_Number and Rank
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL
Using SQL Server Concatenation Efficiently
Using the SQL Server APP_NAME function to control stored procedure execution
Concatenation of Different SQL Server Data Types
Forgotten SQL Server Functions – VARP, SOUNDEX and NTILE
Getting SQL Server Metadata With Python
Retrieving random data from SQL Server with TABLESAMPLE
SQL Server 2016 STRING_SPLIT Function
SQL Server 2008 Functions for Tables, Views, Indexes, Columns, Stored Procedures
Additional SERVERPROPERTY properties in SQL Server
Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
Some names and products listed are the registered trademarks of their respective owners.
SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE
Calculate the Statistical Mode in SQL Server using T-SQL
Name Parsing with SQL Server Functions and T-SQL Programming
New Data Type Conversion Functions in SQL Server 2012
Randomly Retrieve SQL Server Records
CHECKSUM Functions in SQL Server 2005
SQL Servers Lag and Lead Functions to Help Identify Date Differences
Count of rows with the SQL Server COUNT Function
Overview of SQL Server Table-Valued Functions sys.dm_exec_cursors and sys.dm_db_log_info
SQL Server Rounding Functions – Round, Ceiling and Floor
Percent_Rank and Cume_Dist functions in SQL Server 2012
Concatenate SQL Server Columns into a String with CONCAT()
Parsing string data with the new SQL Server 2016 STRING_SPLIT function
Different ways to get random data for SQL Server data sampling
SQL Server TSQL Aggregate Functions
Dealing with the single-character delimiter in SQL Servers STRING_SPLIT function
Dynamically controlling the number of rows affected by a SQL Server query
SQL Server COUNT() Function Performance Comparison
Max, Min, and Avg SQL Server Functions
Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions
Deciding between COALESCE and ISNULL in SQL Server
Name Parsing for Result Sets with Different Name Formats
New Logical Functions in SQL Server 2012 (IIF and CHOOSE)