How Many Pages Are in the Stack? Sunday Puzzle

One pile of overlapping pages, several visible corners. How many sheets are really there?

I used to count a pile of printed execution plans by its height. That was never a very good method. Paper bends, some sheets are thicker, and a single long plan can turn a modest pile into a small mountain. Today's Sunday puzzle lets the eye make a similar mistake in a cleaner way.

The image shows one diagonal stack of data pages. Some pages are almost completely covered. Each sheet has its own top corner peeking out. Count the sheets, not the coloured patches and not the horizontal marks printed on the top page. You may want to start at the back and work forward, or start at the front and work backward. Either route works if you keep one finger on each exposed corner.

Do not worry about SQL Server's real page size here. These are paper cards standing in for pages, and the challenge is purely visual. Once you have a number, check it below.

Several offset paper pages overlap in a diagonal stack. Count the distinct visible corners before reading the answer.

How Many Pages: The Answer

There are eight sheets. The back cream card is one, then each offset corner brings another card forward until the pale front card makes eight. The coloured bands can tempt you to count seven or nine because a card edge and a printed line have similar weight at a glance.

The drawing rule was simple: every new card moves right and down by the same amount, and no card is completely hidden. That gives each card one corner you can count without trusting a vague impression of stack thickness.

This is a little reminder of why I ask for a number and its source. 'Lots of reads' or 'a few pages' may be good shorthand while talking, but they are not measurements. On a real SQL Server, the counters and plan details give us something firmer than the shape of a pile.

If you got eight immediately, well done. If you counted again because one page seemed to vanish behind another, the puzzle did its job. Sunday can be a safe place to practise checking a count twice.

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.


Discover more from SQL Authority with Pinal Dave

Subscribe to get the latest posts sent to your email.

Previous Post
The Missing Data Page: A Sunday Geometry Trick

Related Posts

No results found.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.