What is TABLESAMPLE in SQL Server ?

TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause. The rows retrieved are random and they are not in any order. This sampling can be based on a percentage of several rows. You can use TABLESAMPLE when only a sampling of rows is necessary for the application instead of a full result set.



You May Interest

Using MS SQL Order By

How to Show Line Numbers in MS SQL Server ?

General Information List of All Allowed Databases in MS SQL Serve ...

Getting Rows in a Table in Random Order in MS SQL

How is Change Tracking is Different From Change Data Capture ?