THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

Allen

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

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

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement