I also went for answer 2 for the reasons as laid down by vk-kirov - I think in retrospect the wording 'what type of index (if any) will SQL Server...

Hugo Kornelis (6/25/2012)

---

When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

What convinced me to pick the "wrong" answer was the wording: "can have...

I did divine the correct answer, however I would agree with 'Just a number' that both options would work.

I'm not sure if I agree with those saying that 'Depends on file system' is correct. Of course file systems have hard limits, so do hard drives and SANs but...

I'm an a) for now. We're growing like billy-oh, the company is stable and recruiting, I am in a good position and I have only served about 4 years so...

Well, I think I'll remember this one now anyhow! I did have to check the ON / OFF status and which meant what, as Microsoft do not always seem to...

In the UK this weekend has no extra holiday - but the weather is (unusually!) sunny so it will be barbeque time outside with friends, in general. Looking forward to...

I have to say that I am astonished that I was not crystal clear on this(I got it wrong), after the years I have programmed against SQL Server. In mitigation...

I can kind of enjoy such events and always go along with them, though they always do seem a little icky. We do not have them at my current employment...

I would agree a little context would be nice and that the spelling of 'Data Set' is a little confusing. As I am primarily a dev though it was trivial...

Much as I am frustrated by things I kind of really enjoy working with technology - and I love bending computers to my will - so yes, I'll be here...

sknox (4/16/2012) The question did not ask if the log file would be bigger that a log file generated from a full recovery model database with the same set of...

I've been a bit wary of paying much heed to such lists since a company I worked for entered and won such an award for 'best small company to work...

sknox (4/16/2012)

---

call.copse (4/16/2012)

---

I would go further than the other posters on this thread - sorry, this question and the answer given are just plain WRONG.

See this MSDN blog entry which...

I would go further than the other posters on this thread - sorry, this question and the answer given are just plain WRONG.

See this MSDN blog entry which clearly explains...