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 12»»

I'm from the government and I'm here to help Expand / Collapse
Author
Message
Posted Saturday, February 6, 2010 2:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, July 11, 2010 5:43 PM
Points: 55, Visits: 224
I work for a large Australian government department that is charged with the responsibility of distributing of TENS OF BILLIONs of dollars of taxpayers' money. My unit is the data analysis unit. The following conversation really took place, and is fairly typical of the calibre of conversations in my unit.

Manager of unit walks out of her manager's office (call him Bigwig) over to underling's desk (call him Underling), looks around and leans over speaking in a low voice out of the corner of mouth.

Mgr: "Underling, integers have decimal places don't they? Bigwig's trying to tell me they don't. He's wrong isn't he?"
Underling: (squirming) "...ah..no..."
Mgr: "Well hang on, they CAN have decimal places, can't they?"
Underling: "er...no..."
Mgr: "...but in some cases they can, right?"
Underling: "Don't think so."
Mgr: (annoyed) "Well why not? What's wrong with an integer having decimal places? Why can't 1.3 be an integer?"
Underling: "There's nothing wrong with 1.3 having a decimal place..."
Mgr: "So that's OK?"
Underling: "Yes..."
Mgr: "See I knew it..."
Underling: "...it's just not an integer..."
Mgr: "Hmm I still don't think that's right. Can you quickly check through the data and see whether any of our integers have decimal places? I'm sure Bigwig's wrong."
Underling: "Yep, sure. Could take a few days. We have a lot of data."
Mgr: "Thanks Underling."
Post #861186
Posted Saturday, February 6, 2010 2:23 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
HAHA



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #861189
Posted Saturday, February 6, 2010 10:01 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: 2 days ago @ 1:53 PM
Points: 35,366, Visits: 31,905
Wait just a minute! "It Depends"! You might just be able to get away with it if you set parameter 136 of DBCC TIMEWARP to a negative decimal value!

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #861261
Posted Sunday, February 7, 2010 9:49 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
Fantastic



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #861328
Posted Monday, February 8, 2010 7:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:54 AM
Points: 1,174, Visits: 2,656
Hmm! Sounds familiar

--
Nigel
Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #861676
Posted Tuesday, February 9, 2010 2:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:54 AM
Points: 999, Visits: 871
We had an issue at one place I worked (names withheld to protect the imbeciles) where there was a problem with some development code failing with a truncation error trying to put data into a varchar(50) field. It turns out the developers had allowed the data entry in the application to accept 500 characters figuring the database would "just sort it out".

However the best thing was when the department manager (who went on to become the IT director) called the DBA's into his office and demanded that we check the database for "any more of these varchars"...

We did find quite a few



Post #862279
Posted Tuesday, February 16, 2010 12:23 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:37 PM
Points: 78, Visits: 297
Post #866318
Posted Tuesday, February 16, 2010 4:41 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
I think I worked for this guy.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #866607
Posted Wednesday, February 17, 2010 9:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:20 AM
Points: 787, Visits: 360
I'm troubleshooting an issue with the operations tech at our company before I had remote access and could do such things myself. I'm telling him what to type in the console and I tell him to end the command with a semi-colon. My husband hears me say - "Semi-colon. (pause) Semi-colon. (pause) It's the comma with the dot on top." He practically falls on the floor laughing.
Post #867205
Posted Wednesday, February 17, 2010 1:01 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, July 11, 2010 5:43 PM
Points: 55, Visits: 224
That reminds me of the time I was working with a doctor who had to enter some notes into the system and didn't want to. For diagnosis he typed ":". I said "what does that mean?" He said "constipation". Took me a while to get it (full colon).
Post #867445
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse