Browse by Tags

• Internals

• The Beatles versus the Stones - the explanation

  On December 31 of last year, I posted this brain teaser , promising to post the answer “in a few days”. Apparently, 15 is a few J . In case you have forgotten what the puzzle was about and are too lazy to click the link above, the bottom line is that Read More... Posted Tuesday, January 16, 2007 10:44 PM by Hugo Kornelis | 0 Comments Filed under: Indexing, Internals, Surprise, T-SQL

• The Beatles versus the Stones

  Here’s a nice brain teaser, just before the end of the year. Despite the title, it is related to SQL Server, not to music! A common misconception amongst SQL Server users is that a clustered index on a table will ensure that data is returned in the order Read More... Posted Sunday, December 31, 2006 1:49 PM by Hugo Kornelis | 20 Comments Filed under: Indexing, Internals, Surprise, T-SQL