SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Getting Random Results Posted on SSC

I previously blogged about using newid() to get random ordering and after chatting with Steve about it, decided to write about it a little more detail for two reasons. One is that sites like SSC thrive by increasing their surface area and it's always good to have an article that covers a topic no matter how simple or seemingly obvious. The other is that I was curious to see if anyone would either challenge the 'randomness' or present a better solution. In this case it was the latter and there are some really great follow up posts that not only discuss alternatives but have code posted that let you test and compare them too! That's the reason I say that if you only read the articles you're missing out on half the educational experience - nothing like reading the comments from a half dozen or more interested and enthusiastic SQL professionals to really give you a look at all sides of any issue.

Anyway, if you haven't read it already, it's posted at http://www.sqlservercentral.com/columnists/awarren/3175.asp


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


No comments.

Leave a Comment

Please register or log in to leave a comment.