Wednesday, March 25, 2009

Random Data Sampling Queries in SQL Server 2005

The following query will return a random sampling of data:

SELECT * FROM TBLAPPLICATIONLOG TABLESAMPLE SYSTEM (10 PERCENT); SELECT * FROM TBLAPPLICATIONLOG TABLESAMPLE SYSTEM (200 ROWS); Not only will the records returned be random, but so will the number of rows.

No comments: