http://blogs.msdn.com/mssqlisv/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspxWhen SQL Server has an optimal index that satisfies the search predicates of a query the optimizer performs an index SEEK operation as opposed to an index (or table) scan to retrieve the required rows; this is desirable. Based on this, one may be ledenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/mssqlisv/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx#4496760Tue, 21 Aug 2007 20:37:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:4496760Carpe Datum<p>There are a lot of tools in SQL Server 2005 that will help you with indexes, from enhanced plan diagrams</p> http://blogs.msdn.com/mssqlisv/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx#8552395Mon, 26 May 2008 16:28:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:8552395Grumpy Old DBA<p>I’ve noticed that of late I’ve become a bit more critical of a well known publication that I suspect</p>