Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Whitepapers
Today's Tip
Join
Tutorials
DBA
Dev
BI
Categories
Webcasts
DBA
Dev
BI
Categories
Next Webcast - Manage and Monitor SQL Server - Lots of demos!
SQL Server Functions - System Tips
Browse Categories
Aggregates
Application Development
Change Data Capture
Constraints
Data Science
Data Types
Database Design
Dates
Debugging
Dynamic Management Views
Dynamic SQL
Encryption
Entity Framework
Error Handling
Excel Integration
Full Text Search
Functions - System
Functions - User Defined
Identities
Import and Export
In-Memory OLTP
JOIN Tables
LINQ
Microsoft Access
Microsoft Flow
Paging
Power BI
Python
Query Optimization
Query Plans
Scripts
Service Broker
Spatial Data Storage
SQL Injection
SQL Mgmt Objects (SMO)
Stored Procedures
Synonyms
T-SQL
Table Valued Parameters
Temporal Tables
Testing
Transactions
Triggers
User Defined Type UDT
Views
XML
Aggregate
Count of rows with the SQL Server COUNT Function
SQL Server TSQL Aggregate Functions
Calculations
Max, Min, and Avg SQL Server Functions
Comparison
Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
Concatentation
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
SQL Servers Lag and Lead Functions to Help Identify Date Differences
Logical
New Logical Functions in SQL Server 2012 (IIF and CHOOSE)
Meta Data
Getting SQL Server Metadata With Python
Monitoring
SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
Understanding and Using SQL Server sys.dm_exec_requests
Network
Determine SQL Server Network Protocol Information using T-SQL and DMVs
Numbers
SQL Server Rounding Functions - Round, Ceiling and Floor
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
SQL Server COUNT() Function Performance Comparison
Random Data
Different ways to get random data for SQL Server data sampling
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 2012 Functions - Lead and Lag
SQL Server Ranking Functions Row_Number and Rank
Result Set
Dynamically controlling the number of rows affected by a SQL Server query
Server
Additional SERVERPROPERTY properties in SQL Server
Statistics
T-SQL Starter Statistics Package for SQL Server
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 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
More SQL Server Solutions
