title: Truncate Statement Taking Too much time
body: <p>I have a table Which has more than 1 million records, I have created a stored Procedure to insert data in that table, before Inserting the data I need to truncate the table but truncate is taking too long. </p>
  
  <p>I have read on some links that if a table is used by another person or some locks are applied then truncate takes too long time but here I am the only user and I have applied no locks on that.</p>
  
  <p>Also no other transactions are open when I tried to truncate the table.</p>
  
  <p>As my database is on SQL Azure I am not supposed to drop the indexes as it does not allow me to insert the data without an index.</p>