THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Bookstores and Databases

My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at dinner celebrating my wife's birthday she was telling me about setting up the shelves in the new bookstore they're opening this week in our local community of Brunswick.

A majority of the books they receive as donations are fiction, and they shelve the books in alphabetical order, by author's last name. My thought was "aha - clustered index"!

She then went on to explain that they sometimes ran out of space on a shelf, and had to move books from the end of one shelf down to the next shelf, which would run out of space and they had to move books to the next shelf, etc. Again I thought "cascading page splits".

So I just had to explain to her the concept of FillFactor and if she'd just fill the shelves 80% full she'd have room for these additions. She said that their store wasn't like a traditional store with expected orders coming in so they could plan better. I said the same was true for database tables.

She called me a geek.


Published Wednesday, March 3, 2010 9:36 AM by AllenMWhite



jamiet said:

haha. Nice story Allen. Glad I'm not the only whose mind treats every real life occurence as a SQL analogy!

March 3, 2010 9:37 AM

Rob Farley said:

:) I think most of us are like that... sad cases all of us.

March 4, 2010 4:40 AM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement