Are the posted questions getting worse?

Question

Are the posted questions getting worse?

September 8, 2022 at 3:15 pm

This was removed by the editor as SPAM

Viewing 15 posts - 66,046 through 66,060 (of 66,712 total)

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

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

Jeff Moden wrote:

I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀

Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

😎

Still think of deadlocks as an ailment, no healthy measures will ever apply.

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

Jeff Moden wrote:

I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀

Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

😎

Still think of deadlocks as an ailment, no healthy measures will ever apply.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Eirikur Eiriksson wrote:

Jeff Moden wrote:
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
😎
Still think of deadlocks as an ailment, no healthy measures will ever apply.

Right there with you brother.

"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

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

Grant Fritchey wrote:

Eirikur Eiriksson wrote:
Jeff Moden wrote:
I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". 😀
Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"
😎
Still think of deadlocks as an ailment, no healthy measures will ever apply.
Right there with you brother.

The interesting thing is that in the current environment, we are facing millions of transactions per second, which makes one ponder on transactional latency!!

😎

Only a handful of years ago, I was very proud of 30-50K transactions per second on my systems.

We are now not in the space of milliseconds, only takes a few micro seconds to clog the system.

This reply was modified 2 years, 2 months ago by Eirikur Eiriksson.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.

I was actually proud my database did so well.

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

Steve Jones - SSC Editor wrote:

I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.
I was actually proud my database did so well.

This brings back memories....

😎

Back in the days of SQL Server 7.0, I had a cluster (Wolfpack) as a back end for my web hosting service, every website launch made the cluster rattle. We had a request cache to reduce the load on the databases and often saw 15-20K t/s whilst the cache was initially populated. Ended up writing a pre-load service that scraped the websites for any links or possible users' interactions that would enter or alter the content of the cache. After enabling the pre-load service, we hardly saw any spikes on the databases.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 7

Jeff Moden wrote:

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results? Thanks for the help, folks.
 SELECT  A = 2147483647/1000
        ,B = 2147483648/1000
;

2022-09-08 15_52_41-SQLServer_Jeff_20220908.csv - Excel

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 8

Johan Bijnens wrote:

Jeff Moden wrote:
I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results? Thanks for the help, folks.
 SELECT  A = 2147483647/1000
        ,B = 2147483648/1000
;

That pretty much cinches it. Thanks, Johan.

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 9

What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.

Is that site dead now or is Redgate phasing it out as I see it’s link here in the menu has also gone.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 10

Ant-Green wrote:

What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.
Is that site dead now or is Redgate phasing it out as I see it’s link here in the menu has also gone.

While the link in the menu might be gone, there's still a large "icon" in the lower right of the page if you scroll down to it.

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 11

Removed what's probably an inappropriate rant based on extreme frustration.

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