random randomise randomize data query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chris Morton » random randomise randomize data query

random randomise randomize data query

Rate Topic

Display Mode

Topic Options

Author

Message

kodracon

Posted Wednesday, November 26, 2008 8:48 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

Comments posted to this topic are about the item random randomise randomize data query

Post #609185

Jeff Moden

Posted Wednesday, November 26, 2008 10:17 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893, Visits: 26,765

Yep... 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.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #609560

kodracon

Posted Tuesday, December 02, 2008 12:35 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

i have another methodology for that one. i will submit it soon as i get back to work.

Post #611848

« Prev Topic | Next Topic »

Permissions