One of my responsibilities at work is to oversee our Management System (a SQL database). Since we have over 100 people with the ability to add a person, it is normal to have people replicated on a regular basis. This is caused by being unable to read a person’s handwriting…or we forget to search beyond first/last name…or we just get into a hurry.
But we somehow lost control of these duplicate entries last spring. By June, we had well over 1,000 known duplicates (and 1,000 more “possible duplicates”) in our system. It was very discouraging.
In July, my wife said “enough” and began attacking the list. She monitored when they were created and helped us identify the source. It took weeks of training of our staff and volunteers to reduce the creation rate from 30+ per week down to 3 or 4 per week.
Yesterday…after weeks and weeks of her chipping away at the list….the number hit “0” for the first time in memory. Of course, some new duplicates appeared the next day…but she was not discouraged. The “mountain” had been dismantled by a volunteer who made it her mission to remove it.
How do we eat an elephant? One bite at a time!
Thanks for listening!