As discussed in previous tip which is TIP #33 we can get random result set by using NEWID function. Now same can be achieve by using one more option which is called TABLESAMPLE. We have following syntax for it SELECT * FROM tableName TABLESAME (Number ROWS/PERCENT) For example I am using same Adventureworks database …