Are the posted questions getting worse?

  • TomThomson

    SSC Guru

    Points: 104763

    I had an annoying problem with SQLServer 2016 and 2017.  The latest updates to both were failing with windows update error 0x8024000b.  So I ran sfc /scannow and let it run until it finished.  The ran windows update again.  The SQLServer 2016 update worked, installed correctly.  The SQLServer 2017 update now fails with windows update error 0x8024001e.    Needless to say, the update troubleshooter detects no problem.  The only way I can discover to fix this problem is to reinstall the SSU and then restart the machine; my machine runs windows 10 version 1903 for X64, but the SSU released in June 2019 by MS is for windows 10 version 1809, and the version 1903 SSU and version 1803 SSU were both released in May 2019, so I'm worried that installing the older SSU may cause more problems than it fixes since several June and July updates have been installed on my machine.

    Anyone have any suggestions for a less heavy fix for this particular error?

    • This reply was modified 1 month, 1 week ago by  TomThomson.

    Tom

  • Luis Cazares

    SSC Guru

    Points: 183532

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Phil Parkin

    SSC Guru

    Points: 243549

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

    Your reply, curt though it may be, is still more polite than mine would have been.

    I'd have said: "So what?"

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Sean Lange

    SSC Guru

    Points: 286411

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

    I would have replied something just like that. Maybe something slightly less direct. "Since I am working on performance improvement I would expect a new execution plan. The one was clearly not very good which I why I was working on this in the first place."

    _______________________________________________________________

    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/

  • Luis Cazares

    SSC Guru

    Points: 183532

    Phil Parkin wrote:

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

    Your reply, curt though it may be, is still more polite than mine would have been. I'd have said: "So what?"

    That's because I removed a word and the ALL CAPS.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

     

    I think I'd have asked what his/her concern was. To me, this is a good teaching moment. Someone might expect better performance from the same execution plan, not realizing what a difference means. At least they're looking at execution plans. Now be sure they know why.

  • jonathan.crawford

    SSCertifiable

    Points: 6352

    I just execute all the plans and let SQL sort it out

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

  • Jeff Moden

    SSC Guru

    Points: 994281

    I agree with Steve... this could turn into a great mentor moment.

    --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
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Ed Wagner

    SSC Guru

    Points: 286957

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

      I think I'd have asked what his/her concern was. To me, this is a good teaching moment. Someone might expect better performance from the same execution plan, not realizing what a difference means. At least they're looking at execution plans. Now be sure they know why.

    It's definitely a good teaching moment.  However, knowing me, I would have started out with something like "That's the point" and then gone on from there to explain it.  Yes, it's short and succinct, but it makes the point in 3 words.

  • Luis Cazares

    SSC Guru

    Points: 183532

    Ed Wagner wrote:

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him. This was his reply:

    The sample runs we indicated diffrent plans being used from the original code

    I just wanted to "enthusiastically" reply: "That's the point".

      I think I'd have asked what his/her concern was. To me, this is a good teaching moment. Someone might expect better performance from the same execution plan, not realizing what a difference means. At least they're looking at execution plans. Now be sure they know why.

    It's definitely a good teaching moment.  However, knowing me, I would have started out with something like "That's the point" and then gone on from there to explain it.  Yes, it's short and succinct, but it makes the point in 3 words.

    And as a basic teaching moment, I sent them Gail's article on How to Confuse the SQL Server Query Optimizer. The procedure that I fixed had all the problems listed in there.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Jeff Moden

    SSC Guru

    Points: 994281

    Has anyone had any dealings with NewEgg.com?  They've got 1 heck of a deal on a laptop that I'd like to get but...

    1. They are not BBB accredited.
    2. They've got nothing but bad reviews on the BBB site.  Of course, few people will get onto the BBB site to say a company was good but they are a solid 1 out of 5 stars.

     

    --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
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • jasona.work

    SSC-Forever

    Points: 49864

    Jeff Moden wrote:

    Has anyone had any dealings with NewEgg.com?  They've got 1 heck of a deal on a laptop that I'd like to get but...

    1. They are not BBB accredited.
    2. They've got nothing but bad reviews on the BBB site.  Of course, few people will get onto the BBB site to say a company was good but they are a solid 1 out of 5 stars.

    I used to buy a ton of PC parts from Newegg and never had a problem.  I've largely slowed down my PC parts purchases, so I can't say if they've gone downhill recently or not (My last purchase from them was a KVM cable in May, kind of hard to mess that up.)

    That being said, they've also gone, to some extent, the Amazon route.  Some items, rather than being sold by Newegg, are being sold by "partners," who could be less than good.

  • Jeff Moden

    SSC Guru

    Points: 994281

    Thanks, Jason. Nice to hear from someone that's "actually been there and done that".

    And, yeah... I picked up on the fact that they used partners as Amazon does.

    Here's what I'm thinking about getting.  I'm calling it my "retirement laptop".   It should get me through the next half dozen revisions of SQL Server. 😀 I also settled on "just" 32GB of RAM because 64 GB added an extra $400 to the price.  It would be nice to have from some bragging rights but I'm having a hard time justifying the need for even 32GB on a laptop.

    https://www.newegg.com/p/2WC-000N-004G4

    One of the things that really caught my eye was the claim that no "bloatware" is installed like some companies do.  I also like their special cooling system with the dust ejector channels.

    My only concern at this point is that the battery pack is only 3 cell/45 watt hours.  But, again, where am I going to be where I might need more than the paltry 2.5 hours (max) of cordless time?

    Still thinking about it, though.  I don't make these kinds of purchases on a whim.

    If anyone else has a suggestion for a "retirement laptop" that can run SQL Server Developer's Edition in a spritely manner, I'm open to suggestions.

    --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
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    Jeff Moden wrote:

    Thanks, Jason. Nice to hear from someone that's "actually been there and done that". And, yeah... I picked up on the fact that they used partners as Amazon does. Here's what I'm thinking about getting.  I'm calling it my "retirement laptop".   It should get me through the next half dozen revisions of SQL Server. 😀 I also settled on "just" 32GB of RAM because 64 GB added an extra $400 to the price.  It would be nice to have from some bragging rights but I'm having a hard time justifying the need for even 32GB on a laptop. https://www.newegg.com/p/2WC-000N-004G4 One of the things that really caught my eye was the claim that no "bloatware" is installed like some companies do.  I also like their special cooling system with the dust ejector channels. My only concern at this point is that the battery pack is only 3 cell/45 watt hours.  But, again, where am I going to be where I might need more than the paltry 2.5 hours (max) of cordless time? Still thinking about it, though.  I don't make these kinds of purchases on a whim. If anyone else has a suggestion for a "retirement laptop" that can run SQL Server Developer's Edition in a spritely manner, I'm open to suggestions.

    Looks a bit pricey given that slightly less RAM and SSD will cut around $1K of the price but upgrading cost 1/3 of that!

    😎

     

  • Jeff Moden

    SSC Guru

    Points: 994281

    Now there's an option I'd not considered, Eirikur!  Thanks for the EXCELLENT tip!

    Also, how do folks feel about a Thunderbolt 3 port?  I don't personally see the need, especially with things like wireless printers, etc, being available, but I've been wrong about such things before.

     

    --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
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

Viewing 15 posts - 63,841 through 63,855 (of 63,950 total)

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