SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


I'm from the government and I'm here to help


I'm from the government and I'm here to help

Author
Message
GOC-481399
GOC-481399
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 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."
SQLRNNR
SQLRNNR
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40289 Visits: 18565
HAHA



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114673 Visits: 41394
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
SQLRNNR
SQLRNNR
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40289 Visits: 18565
Fantastic:-D



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

nigel.
nigel.
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2116 Visits: 2877
Hmm! Sounds familiar :-P

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

Andeavour
Andeavour
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1124 Visits: 932
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 w00t



NatalyaM
NatalyaM
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 422
Hehe
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81756 Visits: 19211
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
My Blog: www.voiceofthedba.com
jkoon-760461
jkoon-760461
SSC Eights!
SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)SSC Eights! (817 reputation)

Group: General Forum Members
Points: 817 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.
GOC-481399
GOC-481399
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 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).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search