title: difference between varchar(500) vs varchar(max) in sql server
body: <p>I want to know what are pros and cons while using varchar(500) vs varchar(max)  in terms of performance, memory and anything else to consider?</p>
  
  <ul>
  <li>Will both use same amount of storage space?</li>
  </ul>
  
  <p>Is the answer differ in case of sql server 2000/2005/2008?</p>