Itzik Ben-Gan, the author of the two SQL books I mentioned in a previous post, also has an article on the TABLE SAMPLE clause. This is a still a good read, even if you’ve read the article over on Fotia.
In my view this new clause can be used for two purposes.
- The new starter: will use it to get to know the contents of a database.
- The perfect tester: will use it to prove that tests can run as planned against random data.
Let me know if you can think of any other scenarios.