random randomise randomize data query

Question

random randomise randomize data query

kodracon

Ten Centuries

Points: 1027
More actions
November 26, 2008 at 8:48 am

#201765

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004589 More actions · Answer 1

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kodracon Ten Centuries Points: 1027 More actions · Answer 2

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

random randomise randomize data query

Cookies on SQLServerCentral