Getting random data out of SQL Server
SQL Server is excellent for storing data and passing it back in nice ordered blocks, but what happens if you just want to take a random selection of data for example a random list of customers to test a new marketing campaign on. Since SQL2005 there has been a clause called TABLESAMPLE that will allow […]