So there I was...

Slacker007

PIEBALDconsult wrote:

But that can wait for next year.

Don't do today what can be done tomorrow. Words to live by, for sure. :thumbsup:

dandy72

Me and one of my coworkers do that all the time. We'll get stuck on a problem, I'll call him on Teams, or he'll call me, and just the fact that we have to describe the problem will often lead to the answer without the other person ever saying a word. I've also heard it being described as "trying to explain it to your dog". :-) If you understand the problem well enough to do that, you'll probably be able to find your own answer.

PIEBALDconsult

"Don't put off for tomorrow what can be put off for the day after tomorrow." -- possibly Mark Twain Edit: In this case, someone else will be replacing my existing SSIS ETL with another technology next year.

Slacker007

On occasion, over the years, I have actually woken up in the middle of the night, instantly knowing the solution to the problem, as if it was magically planted in my brain. It's the weirdest and strangest thing how that works. Every time, the solution works.

JudyL_MD

It's happened to me often enough that I keep a pad and pen on my nightstand, along with a little flashlight so I can write down the solution; the flashlight is so I can do it without waking up the spouse :-D. And you're right -- the idea always handles the problem, be it bug or design conundrum.

Be wary of strong drink. It can make you shoot at tax collectors - and miss. Lazarus Long, "Time Enough For Love" by Robert A. Heinlein

charlieg

Happens to me a lot when I'm in the shower. The mind is a wonderful thing.

Charlie Gilley “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759 Has never been more appropriate.

Gary R Wheeler

PIEBALDconsult wrote:

suspect that someone upstream of me is messing with the data

I always assume that someone upstream is :elephant:ing with the data, and they're not wearing a condom. Best example: I communicate with a device that routinely returns uninitialized data in its responses. The schmuck responsible for the device code complains that guaranteed and complete initialization makes the code take an extra couple of seconds to start under the debugger :doh: .

Software Zen: delete this;

jmaida

tomorrow is always another tomorrow -- manana

"A little time, a little trouble, your better day" Badfinger

PIEBALDconsult

If it's .net (and I guess it isn't) then test for an attached debugger and act accordingly.

dandy72

Same. There's been instances where I got out of bed to scribble some notes, otherwise I know I will have forgotten all about it by morning. Either that or I'll be so worried I'll forget some important detail I can't relax and go back to sleep.