>>select top 14 * from myTable order by NewID()
>
>Thanks, this works.
>
>I assume this will always be optimized even on a two million records table.

As far as I know select TOP is not optimizable at all, but I'll verify just in case.

In any way, this is the technique to get random records in SQL Server.

Interesting read

http://technet.microsoft.com/en-us/magazine/2007.11.sqlquery.aspx

http://blogs.msdn.com/queryoptteam/