Geekularity

You realize that you are deep (perhaps too deep) in the world of information technology when an acquaintance calls you asking if you remember the subnet and router address of a network that you setup but have not touched in three years, and you can recall that information, including passwords, immediately from memory; yet, you have trouble remembering what’s on your calendar for tomorrow.

I need a function where I can regularly purge that semi-useless crap out of my brain so that I can remember the important stuff like birthdays, anniversaries and the TV schedule for the Discovery Channel’s “Great Biker Build-Off!” What’s sad is that as I am writing this, I am imagining how this function would be built. What’s worse is that I can actually picture the Transact-SQL code in my head!

BEGIN TRAN ‘purgeUselessCrap’
SELECT * INTO tempBrain FROM realBrain WHERE relevenceFactor > 50 AND dateLastUsed <= DATEADD(year, -1, GETDATE());
GO
TRUNCATE TABLE realBrain;
GO
SELECT * INTO realBrain FROM tempBrain;
GO
TRUNCATE TABLE tempBrain
GO
COMMIT TRAN ‘purgeUselessCrap’