Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Santa's List Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 9:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:34 PM
Points: 2,341, Visits: 1,401
Got it, and thanks.

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

M.


Not all gray hairs are Dinosaurs!
Post #1400290
Posted Wednesday, December 26, 2012 12:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 12:25 PM
Points: 347, Visits: 1,068
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....
Post #1400323
Posted Wednesday, December 26, 2012 11:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 13,741, Visits: 10,716
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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1400475
Posted Monday, December 31, 2012 9:51 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 8,844, Visits: 9,406
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
Post #1401425
Posted Tuesday, January 1, 2013 11:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:01 PM
Points: 1,287, Visits: 1,122
Gifted question. 7 points for that. Thanks Steve.
Post #1401669
Posted Thursday, January 10, 2013 1:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
OK, I hate to start nitpicking, but the correct answer is missing:
For 7 rows you definitively need NO index to improve performance


Best Regards,
Chris Büttner
Post #1405268
Posted Thursday, August 21, 2014 3:36 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:39 AM
Points: 2,935, Visits: 239
I just love these big point questions.
Post #1606057
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse