Santa's List

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Santa's List

16 posts, Page 2 of 2

««1 2

Santa's List

Rate Topic

Display Mode

Topic Options

Author

Message

Miles Neale

Posted Wednesday, December 26, 2012 9:49 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 1,891, Visits: 936

Got it, and thanks.

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

M.

Not all gray hairs are Dinosaurs!

Post #1400290

john.moreno

Posted Wednesday, December 26, 2012 12:08 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:31 PM
Points: 339, Visits: 950

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.... Wink

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

Post #1400323

Koen Verbeeck

Posted Wednesday, December 26, 2012 11:44 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

W00t

7 easy points! Smile

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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1400475

L' Eomot Inversé

Posted Monday, December 31, 2012 9:51 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 7,087, Visits: 7,142

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1401425