What is Table Sample in SQLServer2008
| TABLE SAMPLE helps us to extract a sampling of rows in a table from the FROM clause. It retrieved random rows and which are not in any order. This sampling can be based on a percentage of number of rows. We can use TABLE SAMPLE when only a sampling of rows is necessary for the application instead of a full result set. | |