Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Santa's List


Santa's List

Author
Message
Miles Neale
Miles Neale
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2668 Visits: 1694
Got it, and thanks.

5 of 7 for this type of year would be excellent!

M.

Not all gray hairs are Dinosaurs!
john.moreno
john.moreno
Old Hand
Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)

Group: General Forum Members
Points: 375 Visits: 1112
SanDroid (12/26/2012)
In order for the elves to find the items

A spatial index is the only right one for this task.
Since Elves do not exist on this Planet/Reality it was the only thing that made sense.... ;-)

Right choice, wrong reason -- it should be a spatial index because Santa makes his deliveries by region (just think of all of the extra travel, if he first delivered in Hong Kong and then NY, and then California and then Germany, not to mention the problem of sunrise...it has to be a spatial index).

Or not....Unsure
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16461 Visits: 13207
W00t w00t 7 easy points! :-)
Merry christmas, channukah, druidfest etc. for everyone!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10731 Visits: 12019
I quite like this question. It make me wonder rather a lot. And dither.

In fact I dithered almost hopelessly on on this one. Should I pick a UNIQUE index because that's the only one I can't find a reason for, and some of the earlier humour questions have made me think I'll never understand American humour? Then I was wondering whether an XM[as]LIndex might be the one (is there anything humorous to an American in substituting "LIndex" for "as" - is LIndex perhaps some American brandname the rest of the world has never heard of, like whatever it is we are calling those short articles that fill the gaps, that might be humprous in a Christmas context? Or could it even be a spatial index - but no, to get round all those chimneys in the available time Santa would need a hyperspatial index - or could the omission of "hyper" be an example of US humour?

But then I picked filtered, becuase it's the only one for which there's a good sound non-humorous reason! Oh dear, apparently American humour, as before, is something that this poor Scot can't see the humopur in! But I can't complain, I got my seven points.

Tom

baabhu
baabhu
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1417 Visits: 1215
Gifted question. 7 points for that. Thanks Steve.
Christian Buettner-167247
Christian Buettner-167247
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2951 Visits: 3889
OK, I hate to start nitpicking, but the correct answer is missing:
For 7 rows you definitively need NO index to improve performance :-P

Best Regards,

Chris Büttner
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search