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 @ 9:01 AM
Points: 6,705, Visits: 1,680
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 @ 10:42 AM
Points: 20,460, Visits: 14,086
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: Wednesday, April 16, 2014 9:32 PM
Points: 1,315, Visits: 485
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: Monday, March 10, 2014 1:08 AM
Points: 130, Visits: 795
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: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
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: 2 days ago @ 7:06 AM
Points: 2,404, Visits: 7,311
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: Thursday, January 23, 2014 2:59 AM
Points: 11, Visits: 53
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: Monday, March 10, 2014 1:08 AM
Points: 130, Visits: 795
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 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...
Post #1183017
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse