title: Will adding a nonclustered index lock my table?
body: <p>I have a table with ~2 million records in and I need to add a new nonclustered index to a uniqueidentifier to improve query performance.</p>
  
  <p>Will adding a nonclustered index lock the table or otherwise degrade performance significantly while it's being applied?</p>
  
  <p>There's lots of information out there about the benefits/pitfalls of indexing, but I can't find anything that tells me that happens <em>during</em> an indexing operation</p>
  
  <p>I'm running SQL Server 2008 R2 (on Windows Server 2008 if that's important)</p>
  
  <p>EDIT: It's the Enterprise Edition</p>