Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,101 through 20,115 (of 66,742 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.

IMO, it wasn't snippy at all. In fact, I might have sent them a lmgtfy link, instead of just suggesting google.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

WayneS (10/7/2010)
Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
IMO, it wasn't snippy at all. In fact, I might have sent them a lmgtfy link, instead of just suggesting google.

Have you tried Google?

"Your search - -2147218798 - did not match any documents."!!

Even removing the "-" doesn't help, you're left with an obviously rare Essbase error, or telephone numbers :w00t:

^{“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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Greg Edwards-268690 (10/7/2010)
Alvin Ramard (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
Alvin,
Congrats again, and check your email. I sent you a little something as a prize for hitting the mark.
Wow, thanks Steve. i wasn't expecting anything. 🙂
A personal invitation to ThreadAholics Anonymous.....:-D
Both in one day, buy me a lottery ticket.
Greg E

Thanks to Steve, I got a free membership to ThreadAholics Anonymous. My first meeting is tomorrow night. I won't get the details about the 13 step program until then.

You guys should come join us. There's free booze. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Grant Fritchey (10/6/2010)
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?
They're planning to:
A) toss normalization
B) Use GUIDs but no other unique constraints
C) Toss RI because it's "too much work"
D) Use triggers for RI instead
Unless I'm completely missing the boat because of encroaching senility, insanity or just plain old stupidity.

Sounds like insanity to me.

I have to admit to having an instance where I screwed up design and I'm using a trigger enforce RI. Gonna re-work it after a discussion at SQLSaturday #52.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

Jack Corbett (10/7/2010)
Grant Fritchey (10/6/2010)
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?
They're planning to:
A) toss normalization
B) Use GUIDs but no other unique constraints
C) Toss RI because it's "too much work"
D) Use triggers for RI instead
Unless I'm completely missing the boat because of encroaching senility, insanity or just plain old stupidity.
Sounds like insanity to me.
I have to admit to having an instance where I screwed up design and I'm using a trigger enforce RI. Gonna re-work it after a discussion at SQLSaturday #52.

Some folks don't want to listen and have to learn the hard way.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 6

Congrats Alvin... You did it..!!!! Great Job.. 🙂

-Roy

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Chris Morris-439714 (10/7/2010)
Have you tried Google?
"Your search - -2147218798 - did not match any documents."!!
Even removing the "-" doesn't help, you're left with an obviously rare Essbase error, or telephone numbers :w00t:

Maybe someone should tell him to run unlockDB on his planning server? From the information he's provided that's the only suggestiopn anyone could sensibly make. (Why post an Oracle problem on SQLServer Central? Well, maybe because the Oracle discussion forums were belly up earlier today.) But as he says its an update stats error it probably isn't that at all.

Tom

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

Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.

Plus beer's and BBQ are on Alvin when anyone's in Memphis for the rest of the year :hehe::w00t:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.

Sounds like a college exam to me. Or maybe the calculator threw an error while doing homework?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Steve Jones - SSC Editor (10/7/2010)
Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.
Plus beer's and BBQ are on Alvin when anyone's in Memphis for the rest of the year :hehe::w00t:

I think I'll take him up on the BBQ offer.:-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 11

CirquedeSQLeil (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Sounds like a college exam to me. Or maybe the calculator threw an error while doing homework?

The OP didn't ask a question, so why waste your time adding posts to that thread? The ball's been thrown back into the OP's court. Wait for him to answer.

Oh wait, we still have a long way to go before we get to 2 million. Ok, post away. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Alvin Ramard (10/7/2010)
CirquedeSQLeil (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Sounds like a college exam to me. Or maybe the calculator threw an error while doing homework?
The OP didn't ask a question, so why waste your time adding posts to that thread? The ball's been thrown back into the OP's court. Wait for him to answer.
Oh wait, we still have a long way to go before we get to 2 million. Ok, post away. 😀

I'm predicting Oct 7, 2012 is the day we hit 2 meelll-yeeeon posts.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 13

CirquedeSQLeil (10/7/2010)
Steve Jones - SSC Editor (10/7/2010)
Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.
Plus beer's and BBQ are on Alvin when anyone's in Memphis for the rest of the year :hehe::w00t:
I think I'll take him up on the BBQ offer.:-D

I wouldn't have any problem doing that for any of the "regulars" in here.

For those that are not regular in here, maybe prune juice instead of beer. 😛

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 14

CirquedeSQLeil (10/7/2010)
Alvin Ramard (10/7/2010)
CirquedeSQLeil (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Sounds like a college exam to me. Or maybe the calculator threw an error while doing homework?
The OP didn't ask a question, so why waste your time adding posts to that thread? The ball's been thrown back into the OP's court. Wait for him to answer.
Oh wait, we still have a long way to go before we get to 2 million. Ok, post away. 😀
I'm predicting Oct 7, 2012 is the day we hit 2 meelll-yeeeon posts.

And you're going to personally make sure that it does happen? 😛

I bet your fingers will be sore.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Alvin Ramard (10/7/2010)
CirquedeSQLeil (10/7/2010)
Steve Jones - SSC Editor (10/7/2010)
Thanks for the notes, and it was a nice day yesterday. Alvin wins a prize, but everyone is appreciated.
Plus beer's and BBQ are on Alvin when anyone's in Memphis for the rest of the year :hehe::w00t:
I think I'll take him up on the BBQ offer.:-D
I wouldn't have any problem doing that for any of the "regulars" in here.
For those that are not regular in here, maybe prune juice instead of beer. 😛

Is the bottom falling out of your world? Take prune juice...

^{“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