Tag: 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…

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…