- I’m searching through a table with 15 foreign keys trying to find a specific person on a specific day, then find out which foreign keys are actually meaningful. ‘LastModifiedBy’ is one I can probably skip. But this one stored procedure has been my biggest timesaver this week.
sp_fkeys @fktable_name = ‘<TABLENAME>’
- I’m searching through the SALE and TRANS tables trying to find discrepancies. On the surface, they look identical [same number of rows, same number of distinct rows, same dollar total]. But a report I don’t trust anyway says there’s a $4000 difference. I got to say this to Amy Accounting: “I’ll be happy to look into it but it won’t be today; there are too many other important things.”
- I’m running 4 different IM protocols, talking over all of them to coworkers, vendors, friends, and more coworkers.
Finale of Battlestar Galactica tonight, 8pm Central. I’m going to run/walk 7.5 miles tomorrow morning. I’ve got to pick up a new Rock Band guitar controller, new insoles for my running shoes, clean my kitchen, and at some point get 8 hours of sleep.