September 29, 2011 at 6:31 am
tsceurman (9/29/2011)
majorbloodnock (9/29/2011)
For the record, though, the drawers in my pedestal contain the following unexpected items:
- Ink cartridges and blotting paper - I do have a fountain pen, but it's been years since I last used it.
- A bottle of shampoo
- Two spare ties
- Half a bottle of soy sauce
- A spray tin of Ralgex
For whatever reason, I read that item as two spare TIRES, and was impressed by the size of your desk drawers.
It's been a long week.....
Nope, they're round my waist.
Semper in excretia, suus solum profundum variat
September 29, 2011 at 6:32 am
When I moved in my cube I found a TI desktop hexadecimal calculator from the 80s
...
-- FORTRAN manual for Xerox Computers --
September 29, 2011 at 6:47 am
I have virtual junk drawers full of database scripts and notes from old projects, but when it comes to hardware, I tend to throw things away pretty aggressively.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 29, 2011 at 7:07 am
paul.jones (9/29/2011)
When one colleague left we found, along with the usual selection of pens and stuff, some crackers and a range of individually wrapped cheese portions.Unfortunately it took us a while to find them...:sick:
It's also interesting to peruse the virtual junk folders a former employee whose job and workstation one has just taken over. Illegal music downloads, porn, a resume; no wonder they were let go. So it's best to keep the junk out of your work trunk.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 29, 2011 at 7:11 am
My start menu starts to look like a junk drawer. I find useful programs (at the time) and install them and never seem to want to uninstall them so they stick around, although Microsoft is pretty bad too, MS Office, MS SQL Server 2005, MS SQL Server 2008, Visual Studio verions from 2003 to present etc.
When I run out of disk space will go through some of them and see what I can get rid off, but I could use just about everything someday so I look else where for the drive space.
September 29, 2011 at 7:39 am
Why does nobody have a deck of cards?
I've got 5 in my work drawer and approximately 60 (yes, 60 brand new decks) in a box at home.
That's not really junk though...
September 29, 2011 at 7:48 am
My physical junk drawer includes: toothbrush, toothpaste, comb, pens, utility knife, spare meds (in case i forget to take them at home), otc pain meds, dark chocolate, spare USB charger (universal), cups of fruit with long expiration dates, cash, headphones, an Atkins bar and dry erase markers.
My virtual junk drawer (OneNote) includes CYA email messages, scripts, project maps, blogs I wrote, process docs, attendance tracking, research docs, jokes, vendor info and presentation notes.
I'm not sure that all of that stuff is junk, but its what I keep.
September 29, 2011 at 7:50 am
You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"
So, getting back to database design, I guess that one EAV might not be that bad. Maybe two. Three? Well, why not?
One table to hold all rows
But there's no way to find them.
One thing to hold all user things
And through obfuscation blind them.
Sorry J.R.R.
ATBCharles Kincaid
September 29, 2011 at 8:27 am
Charles Kincaid (9/29/2011)
You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"So, getting back to database design, I guess that one EAV might not be that bad. Maybe two. Three? Well, why not?
One table to hold all rows
But there's no way to find them.
One thing to hold all user things
And through obfuscation blind them.
Sorry J.R.R.
Years ago I was tasked with maintaining a proprietary in-house CRM database, and one of the requirements was to allow the users to create ad-hoc fields for entering data that wasn't covered by columns in the primary client/prospect table. So rather than users entering free form notes, they would occasionally (at their own discretion) create a new field called "Spouse's birthday", assuming the field didn't already exist in the dropdown listbox. The data contained in these "fields" was just extended attributes that would be useful to the client manager when an account profile was opened.
Other popular applications may contain the same in XML columns, text search indexes, or in an external EAV database. You're right that this would be the database equivalent of the "junk drawer", but so long as the data is relevent and easily accessible, it's not really junk.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 29, 2011 at 9:01 am
Speaking of junk drawers.... how many unused tables and stored procedures exist in some of our production databases that have been out there for years?
I have one in particular that predates me by a decade and is full of stuff that probably haven't been used in a long time. We need to take inventory in this database and clean it up because it has turned into a "junk drawer". :w00t:
The probability of survival is inversely proportional to the angle of arrival.
September 29, 2011 at 9:08 am
Charles Kincaid (9/29/2011)
You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"So, getting back to database design, I guess that one EAV might not be that bad. Maybe two. Three? Well, why not?
One table to hold all rows
But there's no way to find them.
One thing to hold all user things
And through obfuscation blind them.
Sorry J.R.R.
Awesome.
Everybody should have at least 1 junk database. We have junk drawers and junk folders - why not a junk database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 29, 2011 at 10:09 am
SQLRNNR (9/29/2011)
Charles Kincaid (9/29/2011)
Everybody should have at least 1 junk database. We have junk drawers and junk folders - why not a junk database?
Truth? I have a development SQL Server my workstation that has junk tables, data, scripts, test stuff from years ago and who knows what all. I also have complete code libraries and copies of old source code locally so I can cut and paste to my hearts content.
Some might call this junk. But to me they are the potential treasures and reminders of lessons learned and pain experienced as I learned. Also there are things that the business has not gotten to yet that I have done research on and have made work that are waiting in the winds.
I have them here so I can find them instead of rebuild them. They are valuable, time saving, mental reminders, and golden technological moments from times past that can be reused now or later.
We are all junk collectors.
Not all gray hairs are Dinosaurs!
September 29, 2011 at 10:15 am
I think that justifies us coining the phrase "code magpie"
Semper in excretia, suus solum profundum variat
September 29, 2011 at 12:31 pm
majorbloodnock (9/29/2011)
I think that justifies us coining the phrase "code magpie"
ME LIKE!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 29, 2011 at 1:46 pm
I want to know how you get by with a single junk drawer! I have at least one in the kitchen, 3-4 in my home office, and I am not even going to talk about the kids rooms!
Dave
Viewing 15 posts - 16 through 30 (of 35 total)
You must be logged in to reply to this topic. Login to reply