title: SQL server - worth indexing large string keys?
body: <p>I have a table that has a large string key (varchar(1024)) that I was thinking to be indexed over on SQL server (I want to be able to search over it quickly but also inserts are important). In sql 2008 I don't get a warning for this, but under sql server 2005 it tells me that it exceeds 900 bytes and that inserts/updates with the column over this size will be dropped (or something in that area)</p>
  
  <p>What are my alternatives if I would want to index on this large column ? I don't know if it would worth it if I could anyway.</p>