Are the posted questions getting worse?

  • Ah... thanks.  I totally missed the link.

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

  • as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    Phil Parkin ducked out way too early on that request.

    MVDBA

  • MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    Phil Parkin ducked out way too early on that request.

    Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<

    Thom~

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

  • MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    ...

    Really depends on the RDBMS being used.  At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things.  Also, I believe there are setting that can change this behavior.

  • Thom A wrote:

    MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    Phil Parkin ducked out way too early on that request.

    Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<

     

    seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users

    MVDBA

  • Lynn Pettis wrote:

    MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    ...

    Really depends on the RDBMS being used.  At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things.  Also, I believe there are setting that can change this behavior.

    it was SQL server - 2017,  turns out the issue was he was coding in VB and passing the VB version of NULL (emptystring) and not DBNULL

    hence set firstname=isnull(@firstname,firstname)

    didn't work how he expected.

    MVDBA

  • MVDBA (Mike Vessey) wrote:

    seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users

    I would rather they were blind... Instead they're in charge of Payroll and expenses. :'(

    Thom~

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

  • MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    Phil Parkin ducked out way too early on that request.

    Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...


  • Phil Parkin wrote:

    MVDBA (Mike Vessey) wrote:

    as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL

    Phil Parkin ducked out way too early on that request.

    Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...

    took your time to wade in at the end 🙂

     

    MVDBA

  • So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I haven't read the email, I was just told by someone else. At a guess, though, there are worries about passing COVID19 around as well as the fact that many attendees come from the recently banned European countries and from countries that President Miller has been asking ICE to stop at the U.S. borders.

    When I heard about COVID19, I was somewhat relieved I forgot about accepting the invite (and hence have no travel plans to cancel). I am not at all surprised today that the entire event is getting cancelled. But disappointed for all the graduate level students who were to present their theses at this event. This is going to hit them hard. Especially the ones who are trying to get attention for the next stage of their careers (and references).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Jeff Moden wrote:

    Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server?  Also, any idea if they support 2019 yet?

    No dev edition. No to 2019

    https://aws.amazon.com/rds/sqlserver/pricing/

     

    SQL Server Editions

    Amazon RDS supports multiple editions of SQL Server (2012, 2014, 2016, and 2017) including Express, Web, Standard Edition and Enterprise Edition.

    Not all editions may be available in all regions; see pricing for details.

  • Sad here that the major volleyball tournament was cancelled. I coached last weekend for the younger kids, but the 16-18s were this weekend. I have kids at all ages I've coached and disappointed I don't get to see them and they can't play, but I think this was the right thing to do

  • Earlier today the school announced that the band trip to Disney was cancelled. There was less than three to go before they got on the bus. Plane tickets, hotels, park tickets, meal vouchers all paid for up front through the school for the whole family. Looks like the virus has crippled me twice now. All told I have lost a little over $5k in cancellations for two trips with little to no chance of getting much more than a couple hundred back.

    _______________________________________________________________

    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/

  • Sorry to hear that, Sean, and hope things go better for you. I've seen many updated policies lately that are suspending some of the cancellation fees and allowing rebooking. So far I haven't gotten charged for things I've cancelled.

  • "Thank you for your kind donation to the local high school band program, in appreciation of your gift, a brick with your name has been placed on the entrance to the football field"

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Viewing 15 posts - 64,621 through 64,635 (of 66,815 total)

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