A bit more on the TABLESAMPLE clause…

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.

  1. The new starter: will use it to get to know the contents of a database.
  2. 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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s