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.