Category: SQL Server

TABLESAMPLE allows you to limit the number of rows from a table in the FROM clause. The rows retrieved are random and they are are…

As part of SQL Server 2016 enhancements, a new built-in table-valued function STRING_SPLIT() is introduced.  This is one of the many enhancements introduced in SQL…

An interesting new enhancement was introduced in SQL Server 2016 SP1. As part of this release, a new T-SQL statement, CREATE OR ALTER was introduced…

Have you ever wondered about the order in which SQL Server query engine executes a SQL query? Most programming languages follow the fundamental of processing…