SQL Server Functions – System Tips

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)

Leave a Reply