Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,011 through 20,025 (of 66,749 total)

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

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

CirquedeSQLeil (10/6/2010)
GilaMonster (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
With a very appropriate post...
Yes - but some bird is whispering to me that he was doing it as a joke too.

No joke.

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]

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

Seriously , really ??!?!?

http://www.sqlservercentral.com/Forums/Topic999726-149-1.aspx

This one is bang on topic, "Are the posted questions getting worse".

Tried to think of a sane , and not to scathing reply , its been a long day.

Clear Sky SQL
My Blog[/url]

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

Grant Fritchey (10/6/2010)
I can't seem to edit the post. It won't go into edit mode when I click on it.

Refresh a couple times. It's because of the fast posting to try and get the 20k

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

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

Alvin Ramard (10/6/2010)
CirquedeSQLeil (10/6/2010)
GilaMonster (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
With a very appropriate post...
Yes - but some bird is whispering to me that he was doing it as a joke too.
No joke.

Shoot, I should have added that line from the Eagles - Hell Freezes Over

"Here's how it all began."

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]

WayneS SSC Guru Points: 95461 More actions · Answer 5

GilaMonster (10/6/2010)
WayneS (10/6/2010)
[Heavy Sigh]
okay, wait mode on. This will be on your blog?
Well, yes. 😀
It's for the T-SQL Tuesday blog 'party' so *shock* *horror* you'll have to wait for the details until tuesday.
I know anticipation is painful but... 😀

Well, it's not hurting. I guess I'm just eager to learn something else that I didn't know.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Dave Ballantyne (10/6/2010)
Seriously , really ??!?!?
http://www.sqlservercentral.com/Forums/Topic999726-149-1.aspx
This one is bang on topic, "Are the posted questions getting worse".
Tried to think of a sane , and not to scathing reply , its been a long day.

hm hmmm. Yeah

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

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

Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not the query that has a problem. It's the interpretation of the request.

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Brandie Tarvin (10/6/2010)
Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not the query that has a problem. It's the interpretation of the request.

That is true. That can be relayed down to business reqs too. It is easy to miss a requirement or to misinterpret the requirement.

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 9

CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.

And with a reference to the start of the thread no less.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

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

Stefan Krzywicki (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
And with a reference to the start of the thread no less.

We're now in an infinite loop. We've entered the Matrix. 😛

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]

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 11

Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
Really? I haven't had any problems with it. What's your issue?
EDIT: Sorry. Thought you were going the opposite direction. From Access to SQL. So, why not just give him a front end .mdb with linked tables?
Heh, no. That's the good way. : -)
Permissions and data security mostly. After I have this working, I'm going to suggest we get him SQL Server Express installed on an isolated server that he can access and load it there. Then we can either give him the front-end mdb or a linked excel workbook or even the SQL Server Express version of SSMS.
Okay, but you can still do this. I do it all the time.
Guy has a domain login, right? On SQL Server, grant db_datareader to only the necessary columns on the necessary tables. Then create Access front end .mdb that links to those tables. I promise, he can't see more than what you let him see. And since he doesn't have SQL Server client tools, he can't get access to the data via SSMS (big assumption I'm making here).
EDIT: Doh, forgot to mention the use of a File System ODBC for the Access db to connect to SQL Server.
The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems and I don't want yet another person hitting the main machine. I'd drop him on Dev, but I don't want to hear it when Dev goes down as it should from time to time.
I appreciate the permissions advice as I don't normally get to play with those and the clarification of what I'd do is very helpful.
One other problem of doing it the way you suggest is convinving the other business people currently hitting the database that his additional access wouldn't cause them problems.

So put Express on his machine and then share it. :w00t:

That is just WRONG having to move a large chunk of data from SQL server to Access.

Greg E

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 12

Alvin Ramard (10/6/2010)
Stefan Krzywicki (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
And with a reference to the start of the thread no less.
We're now in an infinite loop. We've entered the Matrix. 😛

Alvin's the oracle

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 13

jcrawf02 (10/6/2010)
Alvin Ramard (10/6/2010)
Stefan Krzywicki (10/6/2010)
CirquedeSQLeil (10/6/2010)
It looks like Alvin got it.
And with a reference to the start of the thread no less.
We're now in an infinite loop. We've entered the Matrix. 😛
Alvin's the oracle

What timing Alvin. Congrats!

2 years of water cooler talk.

And 2% of the posts by this thread.

Greg E

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Grant Fritchey (10/5/2010)
GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.
I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)
WT!@#$%$#^*&^^$%???????
That is several kinds of messed up. Sorry to hear it. That kind of frustration makes the normal frustrations associated with this business seem that much worse.

In my experience that is the normal frustration you should expect if you have a "project manager" in the loop who is neither a devloper nor a user and give him the ability to wield power even though he hasn't a clue about any aspect of the project except the target date. Gail has my sympathy - these arrogant twerps can be very difficult to deal with.

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 15

Brandie Tarvin (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

I agree. Anyone who thought it over the top would have to be crazy.

Tom