Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 53,056 through 53,070 (of 66,712 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

A sig that claims an MCSA and can't use SUM?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Y.B. SSChampion Points: 11649 More actions · Answer 2

GilaMonster (3/15/2016)
A sig that claims an MCSA and can't use SUM?

You caught that too...makes you wonder if people are using other people's accounts. But why?

SELECT quote FROM brain WHERE original = 1
0 rows returned

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

yb751 (3/15/2016)
GilaMonster (3/15/2016)
A sig that claims an MCSA and can't use SUM?
You caught that too...makes you wonder if people are using other people's accounts. But why?

Probably more like boot camp style exam prep.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

yb751 (3/15/2016)
GilaMonster (3/15/2016)
A sig that claims an MCSA and can't use SUM?
You caught that too...makes you wonder if people are using other people's accounts. But why?

Indeed. Why make such claims in your sig & then demonstrate their lack of validity.

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Sean Lange (3/15/2016)
ChrisM@Work (3/15/2016)
Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a huge amount of effort on his part to learn. I'm willing to help - as are others of course - but I'd like to encourage him to take up the baton rather than simply increase the size of the existing pile of stuff. Feel free to criticize my post if you think it might give him that wee nudge that I think he needs.
On the contrary. I think you were far gentler and nicer than I would have been. That code is an absolute train wreck for what appears to be something relatively simple. He needs to either put on his big boy pants or spend the rest of his career in the kiddie pool.

Cheers Sean, appreciate it.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

Phil Parkin (3/15/2016)
yb751 (3/15/2016)
GilaMonster (3/15/2016)
A sig that claims an MCSA and can't use SUM?
You caught that too...makes you wonder if people are using other people's accounts. But why?
Indeed. Why make such claims in your sig & then demonstrate their lack of validity.

It's as bizarre as making stuff up for your cv.

I wonder if the guy I mentioned earlier ^^ fits into this category? He's certainly struggling with what looks to be fairly straightforward requirements.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

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

Can someone help over on this thread? I'm positive the OP needs to rebuild SQL Server, but he seems certain that his backup strategy works and that the issue is something more easily resolved.

At this point, I'm giving up because the OP isn't listening and everyone else on the thread is asking him to repeat the error he's already posted at least twice because they can't believe that's the only error.

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.

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

Steve Jones - SSC Editor

SSC Guru

Points: 736212

March 15, 2016 at 10:56 am

#1865355

I'm sad today

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

Steve Jones - SSC Editor (3/15/2016)
I'm sad today

Doh!!! That sucks. At least it looks reasonably minor so nobody got hurt!!!

_______________________________________________________________

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/

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

Yeah, actually a girl hit a trailer that slide over and tapped the car. Wouldn't be nearly as bad, but it clipped a coolant line, so no driving 🙁

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Steve Jones - SSC Editor (3/15/2016)
Yeah, actually a girl hit a trailer that slide over and tapped the car. Wouldn't be nearly as bad, but it clipped a coolant line, so no driving 🙁

Wouldn't be surprised if the repair bill hit 5K or more.

I was in a minor rear end accident in my car and the repairs to the rear was close to 2K.

Glad no one was hurt.

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

ChrisM@Work (3/15/2016)
Sean Lange (3/15/2016)
ChrisM@Work (3/15/2016)
Have I been reasonable with this guy? He crops up fairly regularly and is quite obviously well out of his depth - but I don't see a huge amount of effort on his part to learn. I'm willing to help - as are others of course - but I'd like to encourage him to take up the baton rather than simply increase the size of the existing pile of stuff. Feel free to criticize my post if you think it might give him that wee nudge that I think he needs.
On the contrary. I think you were far gentler and nicer than I would have been. That code is an absolute train wreck for what appears to be something relatively simple. He needs to either put on his big boy pants or spend the rest of his career in the kiddie pool.
Cheers Sean, appreciate it.

Chris, I agree with Sean. I thought you were up-front and honest. There's no getting around that it sucks and needs to be rewritten. Now, if he does want someone to do it for him, then let him hire someone. I thought that what you and Lynn said about taking the opportunity to learn and having to support it was really good. You have a great deal of patience.

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

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

Steve Jones - SSC Editor (3/15/2016)
I'm sad today

The important thing is, no one was seriously hurt.

JustMarie SSCertifiable Points: 7771 More actions · Answer 14

Steve Jones - SSC Editor (3/15/2016)
I'm sad today

One bit of advice. Work with your body shop to make sure that the repairs come under the amount where your insurance company would consider the car totaled. It seems minor enough but parts, labor, painting, etc. can add up fast.

Glad no one got hurt except for the car.

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

JustMarie (3/15/2016)

Steve Jones - SSC Editor (3/15/2016)
I'm sad today
One bit of advice. Work with your body shop to make sure that the repairs come under the amount where your insurance company would consider the car totaled. It seems minor enough but parts, labor, painting, etc. can add up fast.
Glad no one got hurt except for the car.

If this can be totaled, I'd be amazed. However, I could live with that. I'll get another one 😉