How many Indexes we can create in a Table Friends, This is becoming a Frequently Asked Question in SQL Server Interviews now a days. How many Indexes we can create in a Table ? Ob ject SQL Server 7 SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2012 Clustered Index 1 1 1 1 1 Non-Clustered Index 249 249 249 999 999 T otal 250 250 250 1000 1000 @SumanJha
Connecting, Sharing and Discovering