I am working on a survey application. I have a sql server database holding upto 3000 survey questions. I call database for a set of 10 questions. I have to make sure
that none of the of the questions are repeated for the longest time possible. What is the best possible approach I can take here? Write a custom randomization
algorithm or SQL server provides some functionality.
Please help me!
Thanks in advance!