>>>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. > >No it's not. IIRC, I posted improved version in UT magazine a while ago but the link http://www.utmag.com/ doesn't work.
Sergey,
You can check all your articles from your profile. I looked through all your articles, but I don't know which one did you mean.