What’s In Your (Junk) Drawers?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQLServerCentral.com » Editorials » What’s In Your (Junk) Drawers?

Add to briefcase

36 posts, Page 1 of 4

What’s In Your (Junk) Drawers?

Expand / Collapse

Author

Message

Posted Wednesday, September 28, 2011 10:06 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the item What’s In Your (Junk) Drawers?

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #1182937

Posted Wednesday, September 28, 2011 11:46 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

How many of us keep that "junk drawer" full of scripts that seem like they could be useful. Just collect a ton of scripts and maybe you will use it and maybe not.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1182951

Posted Thursday, September 29, 2011 12:46 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:17 PM
Points: 1,291, Visits: 408

I hear that! I have a handfull of scripts that I use every day, and folder upon folders of 'one day I'll sit down and sort thorugh this' scripts :)

Post #1182962

Posted Thursday, September 29, 2011 1:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:55 AM
Points: 126, Visits: 751

I even found some UAT (user acceptance test) sign-off's (wet signature on paper!) which were soooo important to collect. After the project nobody dared to file them properly and they rot in my drawer. BigGrin

BigGrin

Otherwise, I try to keep my drawer's clean.

Post #1182969

Posted Thursday, September 29, 2011 1:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,161, Visits: 642

Junk drawers are useful so that you can utter 'Ah, that's where it is...'.

Post #1182981

Posted Thursday, September 29, 2011 2:00 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:16 AM
Points: 2,236, Visits: 6,486

I have no junk drawer. . . no, seriously.

I do have "junk scripts" on a file server though, loads of them that may or may not be useful :)

Not a DBA, just trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...
(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock

LinkedIn | Blog coming soon (for sufficiently large values of "soon" Wink

Wink

)!

Post #1182988

Posted Thursday, September 29, 2011 2:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 8:06 AM
Points: 9, Visits: 45

I have a small junk drawer with pens, pencils (why so many??? Tongue

Tongue

) keys, business cards, paracetamol, staples etc. and I have a big junk drawer with bigger stuff like spare (old) mouses, empty mouse boxes (huh?), multiple utp-cables, a hat (wtf...), a small ball which was thrown at me years ago (hahahha). And I even have a junk drawer from the former owner of my desk. Tongue

Tongue

Oh man... I have to clean up a bit, this is so evil!
Yup I also have a ton of unused scripts. October will be a good month for collecting garbage. Hehe

Hehe

Post #1182995

Posted Thursday, September 29, 2011 2:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:55 AM
Points: 126, Visits: 751

Jon-413357 (9/29/2011)

I have a small junk drawer with pens, pencils (why so many??? Tongue

Tongue

) keys, business cards, paracetamol, staples etc. and I have a big junk drawer with bigger stuff like spare (old) mouses, empty mouse boxes (huh?), multiple utp-cables, a hat (wtf...), a small ball which was thrown at me years ago (hahahha).

ha, ha, that's funny! Well, I have some power adapters and mouses as well but I regard them as valuable items Wink

Wink

Post #1183002

Posted Thursday, September 29, 2011 3:07 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, November 16, 2012 1:36 AM
Points: 89, Visits: 44

It's not a Junk drawer, its a man drawer.

http://youtu.be/RgUpDGAIdds

Post #1183014

Posted Thursday, September 29, 2011 3:07 AM

Old Hand

Group: General Forum Members
Last Login: Monday, January 07, 2013 2:22 AM
Points: 376, Visits: 728

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

Sick

Post #1183017

« Prev Topic | Next Topic »

Add to briefcase

36 posts, Page 1 of 4

Permissions

Expand / Collapse