Are the posted questions getting worse?

Question

Are the posted questions getting worse?

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

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

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 5 years, 4 months ago by TomThomson.

Tom

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

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: 246960 More actions · Answer 3

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?"

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

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: 183706 More actions · Answer 5

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: 736212 More actions · Answer 6

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: 6612 More actions · Answer 7

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: 1004340 More actions · Answer 8

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.

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)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 10

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: 1004340 More actions · Answer 11

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

They are not BBB accredited.
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.

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)

jasona.work SSC Guru Points: 50117 More actions · Answer 12

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...
They are not BBB accredited.
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: 1004340 More actions · Answer 13

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.

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)

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 14

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: 1004340 More actions · Answer 15

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.

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)