Skip to main content

Posts

Showing posts with the label Index

Maximum No of Indexes Per Table

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