Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

What’s In Your (Junk) Drawers? Expand / Collapse
Author
Message
Posted Wednesday, September 28, 2011 10:06 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 1:44 PM
Points: 6,783, Visits: 1,882
Comments posted to this topic are about the item What’s In Your (Junk) Drawers?

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1182937
Posted Wednesday, September 28, 2011 11:46 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:02 PM
Points: 21,657, Visits: 15,326
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


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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, August 31, 2014 9:05 PM
Points: 1,317, Visits: 515
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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 131, Visits: 801
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.
Otherwise, I try to keep my drawer's clean.
Post #1182969
Posted Thursday, September 29, 2011 1:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:47 AM
Points: 2,434, Visits: 7,515
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" )!
Post #1182988
Posted Thursday, September 29, 2011 2:22 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:17 AM
Points: 11, Visits: 59
I have a small junk drawer with pens, pencils (why so many??? ) 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.

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.
Post #1182995
Posted Thursday, September 29, 2011 2:46 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 131, Visits: 801
Jon-413357 (9/29/2011)
I have a small junk drawer with pens, pencils (why so many??? ) 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
Post #1183002
Posted Thursday, September 29, 2011 3:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, January 7, 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...
Post #1183017
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse