Click here to Skip to main content
15,915,611 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
Generalvs2019 size -- Pin
abmv3-Apr-19 4:15
professionalabmv3-Apr-19 4:15 
GeneralRe: vs2019 size -- Pin
Slacker0073-Apr-19 4:18
professionalSlacker0073-Apr-19 4:18 
GeneralRe: vs2019 size -- Pin
honey the codewitch3-Apr-19 4:27
mvahoney the codewitch3-Apr-19 4:27 
GeneralRe: vs2019 size -- Pin
Marc Clifton3-Apr-19 4:37
mvaMarc Clifton3-Apr-19 4:37 
GeneralRe: vs2019 size -- Pin
abmv3-Apr-19 4:44
professionalabmv3-Apr-19 4:44 
GeneralRe: vs2019 size -- Pin
dandy723-Apr-19 10:31
dandy723-Apr-19 10:31 
GeneralRe: vs2019 size -- Pin
Rage3-Apr-19 20:34
professionalRage3-Apr-19 20:34 
GeneralJust Lazy... Pin
#realJSOP3-Apr-19 4:12
professional#realJSOP3-Apr-19 4:12 
Working in the database today...

0) We import data from a remote source, and the data includes several datetime columns taht come over as varchars. This wouldn't be so bad, if after receiving that data, the programmer would have taken the time to convert it to the appropriate datetime datatype. But no.

0.5) We can't change the string date to a datetime, because we don't know exactly where the side effects will crop up, in the database, or in the app itself.

1) We directly modify the table that contains imported data, based on our business rules, and then move that table into the dbo scvhema for use by the application. The data pull is 4-5 hours long, and involves about 30 million records. After post-processing the imported data, if we find an error, we have to re-pull the data because we modified what we imported last time, because post-processing the already-post-processed data woiyuld be an invalid test of the post-processing code.

2) Importing and post-processing is handled by a 77-step sql job.

I talked the DBAs into adding as step to the job that copies the freshly imported data to a different schema so we could at least move it back to effect more timely testing, but FML.

While I was complaining loudly about the state of the data, one of the otrher devs suggested that I go ahead and "fix it", and I actually had to cite item 0.5 as a reason we can't.

This crap shoulda been fixed YEARS ago.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

QuestionRe: Just Lazy... Pin
megaadam3-Apr-19 4:21
professionalmegaadam3-Apr-19 4:21 
AnswerRe: Just Lazy... Pin
#realJSOP3-Apr-19 4:31
professional#realJSOP3-Apr-19 4:31 
AnswerRe: Just Lazy... Pin
OriginalGriff3-Apr-19 4:38
mveOriginalGriff3-Apr-19 4:38 
GeneralRe: Just Lazy... Pin
#realJSOP3-Apr-19 4:57
professional#realJSOP3-Apr-19 4:57 
GeneralRe: Just Lazy... Pin
Marc Clifton3-Apr-19 4:32
mvaMarc Clifton3-Apr-19 4:32 
GeneralRe: Just Lazy... Pin
dandy723-Apr-19 10:30
dandy723-Apr-19 10:30 
QuestionJSON responses -- what's your preference? Pin
Marc Clifton3-Apr-19 2:34
mvaMarc Clifton3-Apr-19 2:34 
AnswerRe: JSON responses -- what's your preference? Pin
W Balboos, GHB3-Apr-19 2:36
W Balboos, GHB3-Apr-19 2:36 
AnswerRe: JSON responses -- what's your preference? Pin
  Forogar  3-Apr-19 2:47
professional  Forogar  3-Apr-19 2:47 
GeneralRe: JSON responses -- what's your preference? Pin
Marc Clifton3-Apr-19 2:52
mvaMarc Clifton3-Apr-19 2:52 
AnswerRe: JSON responses -- what's your preference? Pin
Nish Nishant3-Apr-19 2:53
sitebuilderNish Nishant3-Apr-19 2:53 
AnswerRe: JSON responses -- what's your preference? Pin
megaadam3-Apr-19 3:16
professionalmegaadam3-Apr-19 3:16 
AnswerRe: JSON responses -- what's your preference? Pin
Mike Hankey3-Apr-19 3:24
mveMike Hankey3-Apr-19 3:24 
AnswerRe: JSON responses -- what's your preference? Pin
GuyThiebaut3-Apr-19 3:29
professionalGuyThiebaut3-Apr-19 3:29 
GeneralRe: JSON responses -- what's your preference? Pin
Marc Clifton3-Apr-19 4:13
mvaMarc Clifton3-Apr-19 4:13 
GeneralRe: JSON responses -- what's your preference? Pin
Scott Serl3-Apr-19 6:24
Scott Serl3-Apr-19 6:24 
GeneralRe: JSON responses -- what's your preference? Pin
bence983-Apr-19 22:33
bence983-Apr-19 22:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.