Viewing 6 posts - 1 through 6 (of 6 total)
Christian Buettner (9/5/2008)
The QOTD is correct. You cannot create more than 249 indexes on a table.The referenced MSDN docs are incorrect or at least badly worded.
http://technet.microsoft.com/en-us/library/ms190197.aspx
(And I also tested it)
Good...
September 8, 2008 at 1:40 am
My opinion is that there's rarely a truly right or wrong answer to this kind of question - the real skill lies in understanding the strengths & weaknesses of each...
September 5, 2008 at 6:56 am
The MSDN article referred to is somewhat ambiguous, or perhaps the question is not formulated correctly to support the correct answer.
Ref. MSDN: "You can create up to 249 spatial...
September 5, 2008 at 2:39 am
Trick question. Not funny nor have I learnt anything from it.
September 4, 2008 at 2:32 am
I think this is more or less the outcome of the discussion so far, but I think a combination of limiting the server memory and DBCC FREEPROCCACHE before executing the...
September 4, 2008 at 2:26 am
Good question, but I think it is being confused, including by me, with an UPSERT (as the previous posts' referral to MERGE indicates too).
This question needs more information to answer...
September 4, 2008 at 2:00 am
Viewing 6 posts - 1 through 6 (of 6 total)