InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 17:22:08 GMT20http://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxOK, I hate to start nitpicking, but the correct answer is missing:For 7 rows you definitively need NO index to improve performance :-PThu, 10 Jan 2013 01:51:50 GMTChristian Buettner-167247http://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxGifted question. 7 points for that. Thanks Steve.Tue, 01 Jan 2013 23:45:36 GMTbaabhuhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxI 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.Mon, 31 Dec 2012 09:51:57 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxW00t :w00t: 7 easy points! :-)Merry christmas, channukah, druidfest etc. for everyone!Wed, 26 Dec 2012 23:44:08 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspx[quote][b]SanDroid (12/26/2012)[/b][hr][quote]In order for the elves to find the items[/quote]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.... ;-)[/quote]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:Wed, 26 Dec 2012 12:08:09 GMTjohn.morenohttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxGot it, and thanks.5 of 7 for this type of year would be excellent!M.Wed, 26 Dec 2012 09:49:53 GMTMiles Nealehttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspx[quote]In order for the elves to find the items[/quote]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.... ;-)Wed, 26 Dec 2012 06:53:40 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxVery easily got 7 points...Wed, 26 Dec 2012 04:07:15 GMTDineshbabuhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxHappy Holidays to all :-)CheersTue, 25 Dec 2012 21:43:14 GMTLokesh Vijhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxMerry Christmas :-)Tue, 25 Dec 2012 18:10:27 GMTNarudhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxHave a blessed Christmas, allTue, 25 Dec 2012 08:23:23 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxThanks Steve, and Merry Christmas! You're on Santa's filtered "Nice" List.Tue, 25 Dec 2012 07:36:18 GMTThomas Abrahamhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxYes, Filtered Santa Gifts..Thanks For the question.Happy holidays to all !!!Merry Christmas and Happy New Year !!!!!!!!!!!!Tue, 25 Dec 2012 06:34:03 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxThanks for the question, Steve.And a very happy Christmas to everyone at SQLServerCentral.comTue, 25 Dec 2012 03:10:44 GMTHugo Kornelishttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxHo Ho Ho - Happy Holidays everybody.Mon, 24 Dec 2012 23:10:40 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1400031-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/humor/95661/">Santa's List</A>[/B]Mon, 24 Dec 2012 23:09:41 GMTSteve Jones - SSC Editor