What do you mean by Table Sample?

Add comment

Votes: 1

Comments: 0

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 number of rows. You can use TABLESAMPLE when only a sampling of rows is necessary for the application instead of a full result set.

Others in this Category

	What is an execution plan? When would you use it? How would you view the execution plan?
	Which are new data types introduced in SQL SERVER 2008?
	Q: What are different normalization forms?
	How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
	What is Row_Number()?
	How to find tables without Indexes?
	What is OLTP (Online Transaction Processing)?
	What is View?
	What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
	Q: When do you use WHERE clause and when do you use HAVING clause?
	» More articles