Post reply

TSQL Challenge 50 - Extracting a specifical range from random data wit

  • February 20, 2011 at 10:37 am

    #148475

    Comments posted to this topic are about the item TSQL Challenge 50 - Extracting a specifical range from random data wit

    .

  • February 21, 2011 at 2:18 am

    #1289319

    OK for a 'creativity' query but I feel this does not go well with RDBMS theory...

    Extract 'Odd' lines from an unsorted list? How can anyone treat the Expected Results as every second line in an UNSORTED list?

    Heap != Ordered set.

    Just because it happened in this case (the order returned from the SELECT *) this should NOT be expected to happen again. Now, it probably will in most cases but this is just a side effect of SQL Server have to deal with awkward realities as physical storage and such.

    So, in my book, solving a query that violates database theory is WRONG as it might give the wrong idea of what we are actually supposed to do with our RDBMSes (and HOW we should think while doing it).

    Just my 2 cents.

    Hanslindgren

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply