SQL Server - What do you mean by Table Sample? - Feb 27, 2010
at 11:50 AM by Shuchi Gauri
What do you mean by Table Sample?
TABLESAMPLE allows users to get a sample of set of data from a table without
performing a complete table scan. Data is read at a page level.
Eg:
Select * from tablename TABLESAMPLE (20 PERCENT/ROWS)
SQL Server - What do you mean by Table Sample? - May 05, 2009
at 22:00 PM by Rajmeet Ghai
What do you mean by Table Sample?
TABLESAMPLE is a clause that can be used in a FROM clause query to limit the
number of rows retuned from a result set. This limitation can be specified by
mentioning the “percentage” of rows to be returned.
Example:
Select name, salary FROM employee TABLESAMPLE(10 PERCENT);
An approximate of 10% of rows is returned.
Also read
Answer - It is the process of organizing data into related
table. To normalize database, we divide database into tables.....
Answer - SQL Server database stores information in a two
dimensional objects of rows and columns called table......
Answer - The Bulk Copy is a command utility that transfer SQL
data to or from a data file. This utility mostly used to transfer huge data to
SQL server from other database....
|
