Ben Forta

Blog

May 31, 2006

Hit Me (And Others) On The Head

In anticipation of CFUNITED (25 days to go!), a Flash Wacky Bash The Guru game has been posted online. This is your chance to hit myself, Ray Camden, Michael Smith, Hal Helms, Simon Horwith, and others on the head (if you feel so inclined).

May 25, 2006

Using TABLESAMPLE To Retrieve Partial Resultsets

I just discovered a new SELECT clause that has been added to T-SQL in SQL Server 2005. TABLESAMPLE can be used to return a sampling of rows (either a fixed number or a specified percent of the table rows). Here is how it is used: /* Get a sample 5 rows */ SELECT * FROM table TABLESAMPLE (5 ROWS) /*...

Page 293 of 490 (4893 posts)