Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-28 : 21:05:19
|
David writes "What is the most efficient way of sampling records from a large table - I am talking 3 million records and up with 250+ fields. The sampling should be as random as possible(!). 1 in n (ie every nth record) would be acceptable if it significantly reduces processing time. Any ideas?
SQL Server 2000/Windows 2000" |
|
|
|
|
|
1 in n Sampling