http://blogs.technet.com/b/sql_server_isv/archive/2011/04/15/fundamentals-improving-insert-and-update-performance-by-dropping-unused-indexes.aspx[Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor. In this post, I will look at the other side of the coin and delete indexes that are unused or that cost more resources thanen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/sql_server_isv/archive/2011/04/15/fundamentals-improving-insert-and-update-performance-by-dropping-unused-indexes.aspx#3448621Tue, 23 Aug 2011 11:49:34 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3448621Michael Brönnimann<p>A free Community Edition of SQL Parallel Boost can be downloaded at <a rel="nofollow" target="_new" href="http://sqlparallelboost.codeplex.com">sqlparallelboost.codeplex.com</a></p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3448621" width="1" height="1">http://blogs.technet.com/b/sql_server_isv/archive/2011/04/15/fundamentals-improving-insert-and-update-performance-by-dropping-unused-indexes.aspx#3427369Sat, 07 May 2011 09:54:47 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3427369Michael Brönnimann<p>Parallelization for queries (SELECT) is covered quite well by the SQL engine itself, but when it comes to large volume data modifications (UPDATE, INSERT, DELETE), the standard engine does parallelize towards best use of all available resources (disk, multiple cpu-cores, etc.).</p> <p>Therefore you may also have a look into the approach of SQL Parallel Boost at</p> <p><a rel="nofollow" target="_new" href="http://www.ibax.ch/-IBX-/plain.simpleimagetitletextlinklist.en.solutions.products.parallelboost/default.aspx">www.ibax.ch/.../default.aspx</a></p> <p>This approach can also be used to execute multiple SQL statements in parallel.</p> <p>A purely SQL engine related parallelisation solution takes advantage of minimized complexity and has no &#39;external&#39; components like SSIS involved, Furthermore it&#39;s the best performing solution regarding task splitting and synchronization, as it hasn&#39;t potential connection and communication overhead. The overall performance gain thru parallelisation with SQL Parallel Boost is up to 10 !</p> <p>In case you don&#39;t wan&#39;t to rebuild your own solution, SQL Parallel Boost provides a self-contained pure T-SQL based solution, which can be easily embedded in existing applications and ETL process tasks.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3427369" width="1" height="1">http://blogs.technet.com/b/sql_server_isv/archive/2011/04/15/fundamentals-improving-insert-and-update-performance-by-dropping-unused-indexes.aspx#3421909Fri, 15 Apr 2011 14:41:23 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3421909Josh Turpen<p> &nbsp;Nice articles Ken! &nbsp;It&#39;s a very succinct analysis of SQL server performance issues, and how to correct them. &nbsp;</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3421909" width="1" height="1">