SQL Server Concepts
Posted in SQL Server

SQL Server – TABLESAMPLE, retrieving random data from 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…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

SQL Server – Logical Query Processing phases

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…

Continue Reading...