SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples | Journey to SQL Authority with Pinal Dave

Introduced in SQL Server 2005, TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause. The rows retrieved are random and they are are not in any order. This sampling can be based on a percentage of number of rows. You can use TABLESAMPLE when only a sampling of… Continue Reading...

Source: SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples | Journey to SQL Authority with Pinal Dave