The Number 999 Related to SQL SERVER

Posted by Sahoomanoj27 under Sql Server on 2/6/2012 | Points: 10 | Views : 1683 | Status : [Member] | Replies : 2

999 - this number is related to something interesting with SQL Server - with what this number is associated in SQL Server.

Reply | Reply with Attachment

Posted by: Avdesh on: 2/7/2012 [Member] Starter | Points: 25

0	you can have up to 999 non clustered index per table from SQL Server 2008 onwards but in previous versions this was limited to 249. THANKS REGARDS AVDESH Sahoomanoj27, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/22/2012 [Member] Bronze | Points: 25

0	Nonclustered indexes per table-999 Refer this link http://msdn.microsoft.com/en-us/library/ms143432.aspx http://blog.sqlauthority.com/2009/06/29/sql-server-maximum-number-of-index-per-table/ Sahoomanoj27, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts