SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Santa's List


Santa's List

Author
Message
Miles Neale
Miles Neale
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6621 Visits: 1698
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
SSC Eights!
SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)

Group: General Forum Members
Points: 875 Visits: 1115
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
SSC Guru
SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)

Group: General Forum Members
Points: 145504 Visits: 13350
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50597 Visits: 13157
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
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4117 Visits: 1218
Gifted question. 7 points for that. Thanks Steve.
Christian Buettner-167247
Christian Buettner-167247
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8505 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