Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Indexes in SQL Server 2005 Expand / Collapse
Author
Message
Posted Tuesday, January 19, 2010 2:30 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, November 16, 2014 3:16 PM
Points: 404, Visits: 955
I got the correct answer of 1000 but only because 250 wasnt there which was the correct answer for SQL SERVER 2005. 1000 is correct for SQL SERVER 2008. Hope this will be the last time there is an incorrect question / answer on the site as I always trust it!
Post #849582
Posted Tuesday, January 19, 2010 2:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 2,301, Visits: 1,432
Hi Thanks For Yours Valuable Opinons and Comments..!
Post #849583
Posted Tuesday, January 19, 2010 4:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 3:51 AM
Points: 317, Visits: 57
I got right anwser but it's true for the SQL Server 2008 not for SQL Server 2005.
Please Change the question or add one more option with 250.
Post #849619
Posted Tuesday, January 19, 2010 4:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 9, 2010 2:23 AM
Points: 24, Visits: 85
I've just assumed there was typo and went with the 2008 answer.
Post #849622
Posted Tuesday, January 19, 2010 4:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:45 AM
Points: 2, Visits: 25
Any of the given options are not correct for SQL Server 2005. it is only suitable for SQL server 2008
Post #849633
Posted Tuesday, January 19, 2010 5:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 16, 2010 2:10 AM
Points: 863, Visits: 295
I also assumed that the question was mistyped, that 2008 was intended, rather than the answers being wrong. Maybe the question should be updated to read 2008 rather than 2005?
Post #849641
Posted Tuesday, January 19, 2010 5:44 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 1:17 PM
Points: 1,882, Visits: 481
Sql 2005 only has a max of 250 indexs for a table. The link points to sql server 2008. Where the max indexes for a table is 1000.
Post #849661
Posted Tuesday, January 19, 2010 5:54 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:21 AM
Points: 753, Visits: 172
Good question, but the answer is for SQL Server 2008, not 2005.

Also, the link that is offered as the documentation doesn't says the maximum number of indexes allowed, just redirects you to the "Create Index" T-SQL documentation, and there it doesn't says that amount.


Frank.
Post #849671
Posted Tuesday, January 19, 2010 6:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 2:53 PM
Points: 204, Visits: 43
Please fix the question or the answer options. In 2008 are 1000 indexes or in 2005 are 250.
Post #849685
Posted Tuesday, January 19, 2010 6:43 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
f_ernestog (1/19/2010)
the link that is offered as the documentation doesn't says the maximum number of indexes allowed, just redirects you to the "Create Index" T-SQL documentation, and there it doesn't says that amount.

Check carefully, and you will find the following:

CLUSTERED
A table or view is allowed one clustered index at a time.

NONCLUSTERED
Each table can have up to 999 nonclustered indexes, regardless of how the indexes are created: either implicitly with PRIMARY KEY and UNIQUE constraints, or explicitly with CREATE INDEX.


But there are also XML, full-text, and spatial indexes (as Hugo mentioned earlier). The question doesn't say that we must consider only clustered and nonclustered indexes.
Post #849699
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse