title: Efficiently randomize (shuffle) data in Sql Server table
body: <p>I have a table with data which I have to randomize. By randomizing, I mean use data from random row to update another row in that same column. Problem is that the table itself is big (more than 2 000 000 rows).</p>
  
  <p>I wrote a piece of code which uses while loop, but it's going slow.</p>
  
  <p>Does anyone have any suggestion about more efficient way of achieving randomization?</p>