SQLServerCentral / Discuss content posted by Chris Morton / Article Discussions / Article Discussions by Author / random randomise randomize data query / Latest PostsInstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 20 Mar 2010 17:21:10 GMT20RE: random randomise randomize data queryhttp://www.sqlservercentral.com/Forums/Topic609185-443-1.aspxi have another methodology for that one. i will submit it soon as i get back to work.Tue, 02 Dec 2008 00:35:36 GMTChris MortonRE: random randomise randomize data queryhttp://www.sqlservercentral.com/Forums/Topic609185-443-1.aspxYep... try getting the TOP 10 random rows from a big table that way... hell to pay for performance. Be careful how you use it for that reason.Wed, 26 Nov 2008 22:17:34 GMTJeff Modenrandom randomise randomize data queryhttp://www.sqlservercentral.com/Forums/Topic609185-443-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Randomise+randomize/65033/">random randomise randomize data query</A>[/B]Wed, 26 Nov 2008 08:48:13 GMTChris Morton