Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 9 posts - 66,916 through 66,924 (of 66,924 total)

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

Steve Jones - SSC Editor SSC Guru Points: 743142 More actions · Answer 1

Was? Is? meaning you tried it? If this is your post int he test thread, I see your response with 3 links.

frederico_fonseca SSCoach Points: 16345 More actions · Answer 2

my post had 4 links when I created it.

I have now edited it and added another 3 links (which also failed before if we added a second link to any post

Brandie Tarvin SSC Guru Points: 173151 More actions · Answer 3

Customer: We've been told index maintenance is taking too long because we have hundreds of millions of records in some tables on this VLDB. Data is ITD, so cannot be archived. Can you partition?

Me: Sure. Let me take a look.

First table, 27 columns, 15 indexes and only one column isn't listed in any of those indexes.

Who has the pork chop launcher?

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.

Brandie Tarvin SSC Guru Points: 173151 More actions · Answer 4

I don't know how many of you have seen this, but OUCH. True, funny, painful, true.

https://www.stvn.sh/writing/programming-still-sucks-fqffhyp

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

I tried some things over on that thread where the post-spam-fix fix was being tested. I tried to break it like before and WOO-HOO!!! It looks like we're back in business!!!.

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

Grant Fritchey SSC Guru Points: 399433 More actions · Answer 6

Brandie Tarvin wrote:

I don't know how many of you have seen this, but OUCH. True, funny, painful, true. https://www.stvn.sh/writing/programming-still-sucks-fqffhyp

That was far too close to reality.

And the doll is on fire.

"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

Brandie Tarvin SSC Guru Points: 173151 More actions · Answer 7

SPAM has officially spread to the messages queue. In the past 24 hours, I've gotten 3 messages from the same user that look very spammy.

gsgd

Account

Last login: August 13th 2026

Login count: 5

Reputation: Newbie

Points: 5

Attachments:

You must be logged in to view attached files.

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

Brandie Tarvin wrote:

SPAM has officially spread to the messages queue. In the past 24 hours, I've gotten 3 messages from the same user that look very spammy. gsgdAccountLast login: August 13th 2026Login count: 5Reputation: NewbiePoints: 5

I think they've relaxed a bit on spam because the anti-spam rules were keeping people from posting. For example, me. It's not uncommon for me to answer a post with more than 1 link and it's not uncommon for me to rapidly post more than one reply on any given thread to answer more than one person on the thread.

Getting spam on your private messages on this site is another thing, though. I've never seen that 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)

Jeff Moden SSC Guru Points: 1004773 More actions · Answer 9

Brandie Tarvin wrote:

Customer: We've been told index maintenance is taking too long because we have hundreds of millions of records in some tables on this VLDB. Data is ITD, so cannot be archived. Can you partition? Me: Sure. Let me take a look.
First table, 27 columns, 15 indexes and only one column isn't listed in any of those indexes.
Who has the pork chop launcher?

I'm working with a 3rd party vendor that someone hired without checking with the DBA team that create a product that uses a table with 712 columns. The columns are named after the datatype and which occurrence number the data type is. For some examples..

VARCHAR50_9

VARCHARMAX_7

INT_12

DATETIME_15

For us, most of the columns are null. And, they use SSAS with a ton of views on the table to "customize" their train wreck for us.

Their archive process created a quarter Tera Byte log file and they weren't even aware. Their latest archive process is to delete the latest 3 million rows and replace them with the latest 3 million rows from the source. And, yes... it is actually a DELETE.

And, no... I couldn't make this up if I tried.

And, I almost forgot... they decided to do all of this, including the SSAS stuff, as an afterthought... and they did it on SQL Server Standard Edition and wonder why they're having memory problems, especially with SSAS.

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