Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 66,241 through 66,255 (of 66,549 total)

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

frederico_fonseca SSCoach Points: 16017 More actions · Answer 1

anyone has any ideas regarding this https://www.sqlservercentral.com/forums/topic/deadlock-related-to-autocreateqpstats

frederico_fonseca SSCoach Points: 16017 More actions · Answer 2

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month

can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.

older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

I can't reply as the OP blocked me

Jeff Moden SSC Guru Points: 1003864 More actions · Answer 3

frederico_fonseca wrote:

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month
can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.
older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range
I can't reply as the OP blocked me

It's always a bit amazing to me when the op repeats a question like that. It's also amazing that someone can have worked with SQL for more than a decade and not know something like that nor know how to actually Google such a question. He's also got 16 pages of topics that he started... it not like he's a stranger to anything on this forum. 😀

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

Michael L John One Orange Chip Points: 27038 More actions · Answer 4

Is it Monday? It seems like Monday.

One of my DBA's set up a SQL account, with db_owner on a database in production. The contractors have now raised havoc with this data and database.

The only way we noticed was that their last request failed because the database was created with a space in the name.

And, it was all done in Entity Framework.

It's going to be a LOOOOOOOOOOOONG day.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 5

Yeesh. Your team stacked up a bunch of jenga blocks awfully high. Have fun playing.

"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

Jeff Moden SSC Guru Points: 1003864 More actions · Answer 6

Michael L John wrote:

Is it Monday? It seems like Monday.
One of my DBA's set up a SQL account, with db_owner on a database in production. The contractors have now raised havoc with this data and database.
The only way we noticed was that their last request failed because the database was created with a space in the name.
And, it was all done in Entity Framework.
It's going to be a LOOOOOOOOOOOONG day.

There's a command that you need to execute immediately...

DROP ALL TURD PARTY CODE WITH ROLLBACK IMMEDIATE;

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

homebrew01 SSC Guru Points: 55539 More actions · Answer 7

frederico_fonseca wrote:

I can't reply as the OP blocked me

Why would someone do that ?

frederico_fonseca SSCoach Points: 16017 More actions · Answer 8

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this one

https://www.sqlservercentral.com/forums/topic/changing-excel-download-rendering-format

https://www.sqlservercentral.com/forums/topic/changing-the-excel-rendering-format

https://www.sqlservercentral.com/forums/topic/change-excel-download-column-format-to-text

homebrew01 SSC Guru Points: 55539 More actions · Answer 9

homebrew01

SSC Guru

Points: 55539

March 2, 2023 at 5:50 pm

#4156069

Sounds like he doesn't deserve the help.

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

frederico_fonseca wrote:

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it
https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this one https://www.sqlservercentral.com/forums/topic/changing-excel-download-rendering-format https://www.sqlservercentral.com/forums/topic/changing-the-excel-rendering-format https://www.sqlservercentral.com/forums/topic/change-excel-download-column-format-to-text

Didn't do a deep dive but at least one of those is unanswered from over a year ago. I can't blame the guy for asking again.

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

frederico_fonseca SSCoach Points: 16017 More actions · Answer 11

Jeff Moden wrote:

frederico_fonseca wrote:
I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it
https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this one https://www.sqlservercentral.com/forums/topic/changing-excel-download-rendering-format https://www.sqlservercentral.com/forums/topic/changing-the-excel-rendering-format https://www.sqlservercentral.com/forums/topic/change-excel-download-column-format-to-text
Didn't do a deep dive but at least one of those is unanswered from over a year ago. I can't blame the guy for asking again.

they were (in date order, so reverse of the above) in

5 Oct 2021

8 Dec 2021

10 Jan 2022

so all very near - and 2 of them on same day (2 minute interval).

Jeff Moden SSC Guru Points: 1003864 More actions · Answer 12

Yep... and he never got an answer to his question on any of those. On one of the earlier ones, he did a work around by using VBA , but that's not what he was looking for in any of his posts. Some "forgiveness" seems appropriate here. 😛

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

Jo Pattyn SSC-Dedicated Points: 32070 More actions · Answer 13

Jo Pattyn

SSC-Dedicated

Points: 32070

March 30, 2023 at 12:27 pm

#4167103

The joy of assembling a new pc and it boots

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

Jo Pattyn wrote:

The joy of assembling a new pc and it boots

Does the rig work?

😎

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 15

Of course not. It never works the first time. Usually I need to unplug and replug something.