SQL Server 2014 will offer Clustered Columnstore Indexes. These will offer the performance and compression benefits of column-oriented storage without the need to restrict the underlying table to ...

Non-clustered indexes can be numerous in SQL Server 2008 I remember from my Sybase days that SQL Server tables could support up to 255 indexes. One clustered index and 254 non-clustered indexes.

This is why "clustered index scans" are so painful, they are the equivalent of a table scan on any table which defines a clustered index.<BR><BR>The reason you are getting into deadlock is because ...