Are the posted questions getting worse?

  • Jeff Moden - Tuesday, January 15, 2019 10:19 PM

    You should grab a couple more and share them with Dad if he drinks at all.

    Not sure the hospital would approve and he hasn't had alcohol in a long time.

  • Sean Lange - Tuesday, January 15, 2019 1:10 PM

    Some of the bank security stuff is a total joke. I like how they ask you to add security questions and the options are stupid things that would be readily accessible through public record or easily discovered via social media. Things like, "your favorite food". Seriously? Anybody who knows me knows it is bacon. Or city where you were born? Because that would be challenging to figure out for somebody else. I end up using my password tool to track these stupid questions and provide completely false answers because the real answers would make my account less secure, not more.

    It honestly bugs me that one of the banks I use doesn't allow special characters in my password, and that my memoriable "word" must contains both upper and lowercase letters and numbers (plural). How many words do people know that contains multiple uppercase letters and numbers? :blink: (This is the same bank where I've had to reset my password on numerous occasions because I've "forgotten" it, only to be told I can';t use my current password for my new one when i reset it... /facepalm)

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Lynn Pettis - Tuesday, January 15, 2019 8:39 PM

    Lynn Pettis - Tuesday, January 15, 2019 5:45 PM

    Wow, things are stressing.

    Work seems to be stabilizing at the moment, but they are talking about pimping me out to other parts of Parson to support MS SQL.

    That is good, I think.

    The hard part is coming tonight when I go out to the hospital as dad and I will be meeting hospice.  Not sure what is going on at this time other than dad saying last night was not a good night.

    I'm not ready for this...……...
    Time to get a drink or ten.

    Shit.  Hang in there.

    From my experience?  You're never ready for this.  

    With my mother, it was a much less controlled process - but that might be in part due to the shortage of hospice beds in this country.  I mean, we knew that the hospital was looking to transfer mum, but didn't know where she would end up or when she would be shifted until about two hours before the move happened, and she was in a serious panic as my brother was on his way from Zurich to come visit her in hospital (not hospice) that afternoon.  

    You do what you've got to do, and cope with it the best you can.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • Lynn Pettis - Tuesday, January 15, 2019 10:35 PM

    Not sure the hospital would approve and he hasn't had alcohol in a long time.

    To be sure, it was mostly a metaphor. Like Thomas said, hang in there my friend.

    --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.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Lynn Pettis - Tuesday, January 15, 2019 10:35 PM

    Not sure the hospital would approve and he hasn't had alcohol in a long time.

    All the more reason. I know I'd want one.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thom A - Wednesday, January 16, 2019 1:53 AM

    Sean Lange - Tuesday, January 15, 2019 1:10 PM

    Some of the bank security stuff is a total joke. I like how they ask you to add security questions and the options are stupid things that would be readily accessible through public record or easily discovered via social media. Things like, "your favorite food". Seriously? Anybody who knows me knows it is bacon. Or city where you were born? Because that would be challenging to figure out for somebody else. I end up using my password tool to track these stupid questions and provide completely false answers because the real answers would make my account less secure, not more.

    It honestly bugs me that one of the banks I use doesn't allow special characters in my password, and that my memoriable "word" must contains both upper and lowercase letters and numbers (plural). How many words do people know that contains multiple uppercase letters and numbers? :blink: (This is the same bank where I've had to reset my password on numerous occasions because I've "forgotten" it, only to be told I can';t use my current password for my new one when i reset it... /facepalm)

    I just had to reset a password last night in fact. Not for a bank but for my account on the pizza hut app. Nothing financial so it isn't crucial but...password can't be more than 8 characters and does not allow special characters. What is wrong with these people?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Jeff Moden - Wednesday, January 16, 2019 6:41 AM

    To be sure, it was mostly a metaphor. Like Thomas said, hang in there my friend.

    Irony and sarcasm would have gone over my head last night, and it wasn't the whiskey.  Do have a slight headache this morning.

  • Lynn Pettis - Wednesday, January 16, 2019 8:10 AM

    Irony and sarcasm would have gone over my head last night, and it wasn't the whiskey.  Do have a slight headache this morning.

    Hi Lynn,
    there are times when we must ignore all the externals and focus on what is most important, I for one am going to keep my crossed that everything turns out fine.
    😎
    Best of luck mate!

  • Sean Lange - Tuesday, January 15, 2019 1:10 PM

    Some of the bank security stuff is a total joke. I like how they ask you to add security questions and the options are stupid things that would be readily accessible through public record or easily discovered via social media. Things like, "your favorite food". Seriously? Anybody who knows me knows it is bacon. Or city where you were born? Because that would be challenging to figure out for somebody else. I end up using my password tool to track these stupid questions and provide completely false answers because the real answers would make my account less secure, not more.

    Bacon 
    😎

  • Eirikur Eiriksson - Wednesday, January 16, 2019 8:21 AM

    Hi Lynn,
    there are times when we must ignore all the externals and focus on what is most important, I for one am going to keep my crossed that everything turns out fine.
    😎
    Best of luck mate!

    Unfortunately fine isn't going to be the outcome.  Dad is tired and the treatments (blood transfusions in this case) aren't as helpful as they were.  He has had more transfusions in the last month then all of last year.  He had me cancel his next keytruda (sp ?) treatment his cancer as well.

  • Lynn -

    Sorry to hear about your dad’s struggle.

    Nothing is worse than watching a loved one having health troubles.

    Wish the best for you and family, and that there are some better days and smiles left to share.

    Hope they solve the cancer puzzle soon.

    Seems what works for some is a one and done, while for others it is a treadmill.

    Neighbor is on his 5th run on the treadmill.

    So not a dad, but after 25 years, pretty close friend.

    I can relate to what you are going through.

  • _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange - Wednesday, January 16, 2019 12:21 PM

    Peppa Pig jigsaw.

    β€œWrite the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • Sean Lange - Wednesday, January 16, 2019 12:21 PM

    Now that's hilarious.  I understand the math on it - I shouldn't be alive either.  The lack of an actual count makes the math impossible, but estimates may result in an overflow. πŸ˜›

  • Ed Wagner - Thursday, January 17, 2019 6:20 AM

    Sean Lange - Wednesday, January 16, 2019 12:21 PM

    Now that's hilarious.  I understand the math on it - I shouldn't be alive either.  The lack of an actual count makes the math impossible, but estimates may result in an overflow. πŸ˜›

    I think someone forgot to carry the 1 or something, because that would come out to roughly 918 pieces of bacon each and every day of me existence

    Assuming my reference day was 1/1/2019:I would have to eat 286 years + 1 day "worth" of bacon, i.e. 286*365.25*24*60/9 = 16.7M pieces
    I'm nearing 50 so I'd have 18,200 days to consume that much bacon, which approximates to 918 pieces.

    That is a LOT of bacon πŸ™‚

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 15 posts - 62,956 through 62,970 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply