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

What is Service Broker in SQL Server ?

Creating a View in MS SQL

What are Sparse Columns in SQL Server ?

Making a Backup of MS SQL Database With Query

What are OFFLINE Datafiles with SQL Server ?