title: What is the most efficient way to generate 8 character random alphanumeric string in TSQL?
body: <p>I want to generate a unique 8 character random alphanumeric string in TSQL, for a mail confirm link. We are currently using a <strong>GUID</strong> but it is not very user friendly.</p>
  
  <p>It only really has to obey a few rules:</p>
  
  <ul>
  <li>be 8 Characters long</li>
  <li>be unique</li>
  <li>be generated efficiently</li>
  </ul>