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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s