If you want to select Random top 10 rows from MS sql table then use NEWID() function in order by clause .

For e.g. 
 
  

select top 10 * from xyzTable order by NewID()

This statement will give always random top 10 rows from data table.

This is very helpful for getting lucky draw winners from data base.

select  top 3 from WinnersTable 
                          where CreateDate > '01-jan-2010' 
                          Order By newID()

*Note: it's performance is slow if table size is high.
Any other alternative or trick guys ?