Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 54,196 through 54,210 (of 66,712 total)

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

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

J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
Grumpy DBA (5/18/2016)
jasona.work (5/18/2016)
Brandie Tarvin (5/18/2016)
Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should be trying to control that particular conversation.
Been noticing a lot of rather helpful comments from SS recently. Really starting to believe it's a shared account somewhere...
Or a DBA with multiple personalities. Meet Sybil the DBA.
Could I get a link? I'd like to see this.
thinsk it maybe this thread
http://www.sqlservercentral.com/Forums/Topic1786309-3411-1.aspx
That does not sound like our SS.
maybe not...will we ever know?
at least ""they"" are not resurrecting old scripts with "Thanks for the script" 🙂

Is pp still doing that?

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

J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
Grumpy DBA (5/18/2016)
jasona.work (5/18/2016)
Brandie Tarvin (5/18/2016)
Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should be trying to control that particular conversation.
Been noticing a lot of rather helpful comments from SS recently. Really starting to believe it's a shared account somewhere...
Or a DBA with multiple personalities. Meet Sybil the DBA.
Could I get a link? I'd like to see this.
thinsk it maybe this thread
http://www.sqlservercentral.com/Forums/Topic1786309-3411-1.aspx
That does not sound like our SS.
maybe not...will we ever know?
at least ""they"" are not resurrecting old scripts with "Thanks for the script" 🙂

Don't remind me, I don't know which is worse...the spam or Mr. "Ilove Scripts".

Sorry, the spam is better! It's at least easier to spot! :hehe:

SELECT quote FROM brain WHERE original = 1
0 rows returned

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

GENUINE AMISH SERVERS

Only the best servers hand-built by talented Amish craftsman from the latest (to them) DEC Alpha processors! Each server loaded with a whopping 16MB of 72-pin SIMM RAM and 250MB SCSI-1 hard drives! These servers are capable of running up to one static page website each for as many as 10 clients at a time!

Call 1-900-DIFASPAMMER today!

:hehe:

😀

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

Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
Grumpy DBA (5/18/2016)
jasona.work (5/18/2016)
Brandie Tarvin (5/18/2016)
Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should be trying to control that particular conversation.
Been noticing a lot of rather helpful comments from SS recently. Really starting to believe it's a shared account somewhere...
Or a DBA with multiple personalities. Meet Sybil the DBA.
Could I get a link? I'd like to see this.
thinsk it maybe this thread
http://www.sqlservercentral.com/Forums/Topic1786309-3411-1.aspx
That does not sound like our SS.
maybe not...will we ever know?
at least ""they"" are not resurrecting old scripts with "Thanks for the script" 🙂
Is pp still doing that?

Stupid question, sorry for asking it. 🙁

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

Lynn Pettis (5/18/2016)
Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
Grumpy DBA (5/18/2016)
jasona.work (5/18/2016)
Brandie Tarvin (5/18/2016)
Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should be trying to control that particular conversation.
Been noticing a lot of rather helpful comments from SS recently. Really starting to believe it's a shared account somewhere...
Or a DBA with multiple personalities. Meet Sybil the DBA.
Could I get a link? I'd like to see this.
thinsk it maybe this thread
http://www.sqlservercentral.com/Forums/Topic1786309-3411-1.aspx
That does not sound like our SS.
maybe not...will we ever know?
at least ""they"" are not resurrecting old scripts with "Thanks for the script" 🙂
Is pp still doing that?
Stupid question, sorry for asking it. 🙁

Hey, there could be hope. If SS (one personality, anyway) is being competent and logical, there's hope for PP. Granted, not much hope.

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

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

Tell me, is this (third post) just fixing the symptom, not the problem?

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

Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016?utm_source=facebook&utm_medium=cpc&utm_content=us2&utm_campaign=data-week-2016.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Lynn Pettis (5/18/2016)
J Livingston SQL (5/18/2016)
Lynn Pettis (5/18/2016)
Grumpy DBA (5/18/2016)
jasona.work (5/18/2016)
Brandie Tarvin (5/18/2016)
Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should be trying to control that particular conversation.
Been noticing a lot of rather helpful comments from SS recently. Really starting to believe it's a shared account somewhere...
Or a DBA with multiple personalities. Meet Sybil the DBA.
Could I get a link? I'd like to see this.
thinsk it maybe this thread
http://www.sqlservercentral.com/Forums/Topic1786309-3411-1.aspx
That does not sound like our SS.

Nope, the linguistics are different in that thread.

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

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

Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.

drew.allen SSC Guru Points: 76988 More actions · Answer 10

Lynn Pettis (5/18/2016)
Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.

It was fairly obvious once he actually posted sample data.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

drew.allen (5/18/2016)
Lynn Pettis (5/18/2016)
Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.
It was fairly obvious once he actually posted sample data.
Drew

Not necessarily, could have been to be sure that data that shouldn't be included wasn't. ... Nah, you're right. Should have caught that.

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

Lynn Pettis (5/18/2016)
drew.allen (5/18/2016)
Lynn Pettis (5/18/2016)
Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.
It was fairly obvious once he actually posted sample data.
Drew
Not necessarily, could have been to be sure that data that shouldn't be included wasn't. ... Nah, you're right. Should have caught that.

Hope he takes the hint and can figure out what he needs to do to get his one row result set.

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

Lynn Pettis (5/18/2016)
Lynn Pettis (5/18/2016)
drew.allen (5/18/2016)
Lynn Pettis (5/18/2016)
Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.
It was fairly obvious once he actually posted sample data.
Drew
Not necessarily, could have been to be sure that data that shouldn't be included wasn't. ... Nah, you're right. Should have caught that.
Hope he takes the hint and can figure out what he needs to do to get his one row result set.

Not bad, now he needs to see how it all works and be able to explain it.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 14

Lynn Pettis (5/18/2016)
Tell me, is this (third post) just fixing the symptom, not the problem?

Yes... fixing the problem. And, yes, not grasping the symptom.

A table being 100% replaced like that has no reason to be in a full recovery database. Putting it in a separate database in the simple recovery model and NEVER backing up that database is what I frequently do. Think of it as a "scratch pad" database.

On the other hand, that post didn't address the obvious issue that transaction log file backups were not being taken.

To answer your question, it was good advice but did address the original problem.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 15

jasona.work (5/18/2016)
I'd honestly expect smaller businesses to be the ones that will take longer to move to automation like this, for several reasons. One would be the most obvious, the manpower issue. If you've got two server / network / storage / database / domain / DNS / DHCP / phone system admins, letting them take the time to set up some sort of monitoring / automation solution doesn't *look* like effective use of their time.

I disagree totally. I've been there deciding what to do, as top manager (Tech Director and Temporary acting CEO) in a small business and gone for monitoring and automation. Before that I had sold that idea to the then CEO (an accountant with a Harvard MBA) and he had no problem with grasping those ideas. So my take is that neither technical people (me) nor absolutely non-technical people (that CEO) have any problem with accepting automation as a means to reduce problems - including costs.

Another reason would be the cost of the products that would accomplish the monitoring automation. Using a previous employer as an example, it was felt that the cost of a "off the shelf" SQL backup solution that offered all the features they thought they'd need was too much (RedGate SQL Backup, FWIW,) so the powers-in-charge decreed instead using an open-source solution. Which took more time to get working as needed, means that the only available support is Google, means that when it didn't work as expected the end-users called my employer for help (tying up a support tech,) etc.

My experience tells me that I can gain very great advantages by the sort of automation that I can implement for trivial costs using internal resources and not buying anything. Of course there can be systems with enormous complexity where one might need to buy tools, but my reaction in such cases is to buy the tools because that's obviously going to be cheapest at the end of the day. Yes, some managers are idiots (actually many of the managers I've known) but by no means all, and most will go for automation when it's properly expained to them.

Tom