Are the posted questions getting worse?

Question

Are the posted questions getting worse?

December 12, 2024 at 6:30 pm

This was removed by the editor as SPAM
December 12, 2024 at 6:30 pm

This was removed by the editor as SPAM

Viewing 15 posts - 66,706 through 66,720 (of 66,738 total)

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

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 1

Steve Jones - SSC Editor wrote:

I don't know how many people need the precision Jeff sees issues with. I think most people just need dates and are glad we have that type.

Indeed I literally had the first legitimate use case in 20 years that actually required more precision than just a datetime would give and needed a datetime2.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

Steve Jones - SSC Editor wrote:

I don't know how many people need the precision Jeff sees issues with.

People seem to be missing the point here. The simple fact is that it worked properly since SQL Server 7.0 and it stopped working correctly in 2016. What else is wrong with it that we don't know about because of such "silent failures"? And would tolerate this for 2 decimal place currency values?

The bottom line is that, once again, they broke something that used to work just fine. They're motto seems have become "If it ain't broke, fix it 'til it is". It's like the changes they made to TempDB in 2016... it broke some serious stuff for people like me because of another fault that they didn't fix.

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

David Burrows SSC Guru Points: 65143 More actions · Answer 3

Jeff Moden wrote:

Steve Jones - SSC Editor wrote:
I don't know how many people need the precision Jeff sees issues with.
People seem to be missing the point here. The simple fact is that it worked properly since SQL Server 7.0 and it stopped working correctly in 2016. What else is wrong with it that we don't know about because of such "silent failures"? And would tolerate this for 2 decimal place currency values?
The bottom line is that, once again, they broke something that used to work just fine. They're motto seems have become "If it ain't broke, fix it 'til it is". It's like the changes they made to TempDB in 2016... it broke some serious stuff for people like me because of another fault that they didn't fix.

Wow Jeff 😮 don’t stop there. Get that soap box a bit higher 😳

Just kidding ‘ol friend, just love your posts 🤪

Far away is close at hand in the images of elsewhere.
Anon.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

David Burrows wrote:

Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
I don't know how many people need the precision Jeff sees issues with.
People seem to be missing the point here. The simple fact is that it worked properly since SQL Server 7.0 and it stopped working correctly in 2016. What else is wrong with it that we don't know about because of such "silent failures"? And would tolerate this for 2 decimal place currency values?
The bottom line is that, once again, they broke something that used to work just fine. They're motto seems have become "If it ain't broke, fix it 'til it is". It's like the changes they made to TempDB in 2016... it broke some serious stuff for people like me because of another fault that they didn't fix.
Wow Jeff 😮 don’t stop there. Get that soap box a bit higher 😳
Just kidding ‘ol friend, just love your posts 🤪

With the performance horrors that 2022 brought upon us for the price of $7K per core, I wonder if PostGreSQL has these kinds of problems? 😉 😉 😉

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

Jeff Moden wrote:

The bottom line is that, once again, they broke something that used to work just fine. They're motto seems have become "If it ain't broke, fix it 'til it is". It's like the changes they made to TempDB in 2016... it broke some serious stuff for people like me because of another fault that they didn't fix.

What I know is that the rounding rules in the DATEPART handling changed in 2016, that is the main problem!

😎

The logic is not clear, if you add a millisecond, it may or may not have the desired value....

This table shows milliseconds added to a datetime value, how those vales are reported in both versions and what the datepart function brings back.

MSADDED DATETIME120             DATETIME160              MSEC120 MSEC160
1       2024-11-13 15:15:50.000 2024-11-13 15:15:50.000     0        0
2       2024-11-13 15:15:50.003 2024-11-13 15:15:50.003  3000     3333
3       2024-11-13 15:15:50.003 2024-11-13 15:15:50.003  3000     3333
4       2024-11-13 15:15:50.003 2024-11-13 15:15:50.003  3000     3333
5       2024-11-13 15:15:50.007 2024-11-13 15:15:50.007  7000     6666
6       2024-11-13 15:15:50.007 2024-11-13 15:15:50.007  7000     6666
7       2024-11-13 15:15:50.007 2024-11-13 15:15:50.007  7000     6666
8       2024-11-13 15:15:50.007 2024-11-13 15:15:50.007  7000     6666
9       2024-11-13 15:15:50.010 2024-11-13 15:15:50.010 10000    10000
10      2024-11-13 15:15:50.010 2024-11-13 15:15:50.010 10000    10000
11      2024-11-13 15:15:50.010 2024-11-13 15:15:50.010 10000    10000
12      2024-11-13 15:15:50.013 2024-11-13 15:15:50.013 13000    13333
13      2024-11-13 15:15:50.013 2024-11-13 15:15:50.013 13000    13333
14      2024-11-13 15:15:50.013 2024-11-13 15:15:50.013 13000    13333
15      2024-11-13 15:15:50.017 2024-11-13 15:15:50.017 17000    16666
16      2024-11-13 15:15:50.017 2024-11-13 15:15:50.017 17000    16666
17      2024-11-13 15:15:50.017 2024-11-13 15:15:50.017 17000    16666
18      2024-11-13 15:15:50.017 2024-11-13 15:15:50.017 17000    16666
19      2024-11-13 15:15:50.020 2024-11-13 15:15:50.020 20000    20000
20      2024-11-13 15:15:50.020 2024-11-13 15:15:50.020 20000    20000
21      2024-11-13 15:15:50.020 2024-11-13 15:15:50.020 20000    20000
22      2024-11-13 15:15:50.023 2024-11-13 15:15:50.023 23000    23333
23      2024-11-13 15:15:50.023 2024-11-13 15:15:50.023 23000    23333
24      2024-11-13 15:15:50.023 2024-11-13 15:15:50.023 23000    23333
25      2024-11-13 15:15:50.027 2024-11-13 15:15:50.027 27000    26666

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 6

Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?

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 SSC Guru Points: 1004406 More actions · Answer 7

Brandie Tarvin wrote:

Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?

I posted a take at the following post on that thread...

https://www.sqlservercentral.com/forums/topic/microsoft-recommendations-for-update-stats#post-4487455

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

David Burrows wrote:

Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
I don't know how many people need the precision Jeff sees issues with.
People seem to be missing the point here. The simple fact is that it worked properly since SQL Server 7.0 and it stopped working correctly in 2016. What else is wrong with it that we don't know about because of such "silent failures"? And would tolerate this for 2 decimal place currency values?
The bottom line is that, once again, they broke something that used to work just fine. They're motto seems have become "If it ain't broke, fix it 'til it is". It's like the changes they made to TempDB in 2016... it broke some serious stuff for people like me because of another fault that they didn't fix.
Wow Jeff 😮 don’t stop there. Get that soap box a bit higher 😳
Just kidding ‘ol friend, just love your posts 🤪

No soap box... beating on a trash can. 😀

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

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 9

So on a whim (because health insurance is going to make me take a paycut next year even if I get a raise), I started checking out salary info for senior DBAs in the SQL Server space.

I googled "SQL Server senior dba tech lead salary" and the top 3 results are from Glassdoor which is saying that 2023 average was $126,548 per year. And 2024, the estimated total pay is $119,824.00 per year.

That means this year pay checks are down instead of up.

That can't be right, can it?

Has anyone else seen this trend? Are we suddenly losing our value?

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.

Eric M Russell SSC Guru Points: 125562 More actions · Answer 10

Brandie Tarvin wrote:

So on a whim (because health insurance is going to make me take a paycut next year even if I get a raise), I started checking out salary info for senior DBAs in the SQL Server space.
I googled "SQL Server senior dba tech lead salary" and the top 3 results are from Glassdoor which is saying that 2023 average was $126,548 per year. And 2024, the estimated total pay is $119,824.00 per year.
That means this year pay checks are down instead of up.
That can't be right, can it?
Has anyone else seen this trend? Are we suddenly losing our value?

Glassdoor is not the best source of information, and googling not the best way to arrive at the result.

Salary.com uses data from a variety of sources and provides detailed reports based on position, years in role, region, and a number of other variables. You do have to pay for the report though.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 11

It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger people have an aversion to the title, DBA. They are data engineers, data architects, data developers, anything but an administrator. Job is still the same though.

"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

Ross McMicken SSCarpal Tunnel Points: 4438 More actions · Answer 12

Grant Fritchey wrote:

It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger people have an aversion to the title, DBA. They are data engineers, data architects, data developers, anything but an administrator. Job is still the same though.

It probably doesn't help that basic tasks are migrating to MSPs in India and other low cost countries, at least for large companies.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 13

Interviewing for open position...

My boss: Rate your SQL skills & knowledge on a scale of 1 to 10.

Interviewee: 7 or 8

Me: Let's talk about backups and restores.

Interviewee: I have no experience with backups and restores.

Me: Okay, let's chat about security.

Interviewee: I don't know anything about security.

I just wanted to cry. I mean, really? The two basic fundamentals I believe ALL DBAs should know, especially one who rates their skills so high, and you don't know ANYTHING?

Is it just a me problem? Or does everyone else here expect at least a little knowledge in those areas for every hire?

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.