title: How to drop all of the indexes except primary keys with single query
body: <p>I am planning to drop all of the indexes except the primary keys. I made the primary keys myself but all other indexes was suggestion of SQL Server. </p>
  
  <p>After dropping all indexes which are not primary keys, planning to use SQL Server profiler tuning template for database tuning advisor and create indexes. </p>
  
  <p>With this way planning to not have unused indexes or performance degrading indexes.</p>
  
  <p>How logical is this ?
  Thank you.</p>