Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,096 through 55,110 (of 66,549 total)

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

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not Spanish :-D).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jasona.work SSC Guru Points: 50083 More actions · Answer 2

Luis Cazares (7/27/2016)
It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not Spanish :-D).

I'd say everyone has been doing well on that topic...

Although it has given me flashbacks to high school Spanish classes...

Not that I know one word in twenty that are being used...

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

Sean Lange (7/27/2016)
jasona.work (7/27/2016)
Sean Lange (7/27/2016)
Lynn Pettis (7/27/2016)
I just love people that want others to do their job for them.
I have no words...
Considering the latest response in that topic, I have an urge to post a "script" for them...
@echo off
c:
cddel * /s/q
But I won't...
They might try to run it...
LOL. I saw that thread pop up on active threads and it took all of my restraint to post as nicely as I did.

I added a bit more to what you posted, Sean.

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

Luis Cazares (7/22/2016)
Brandie Tarvin (7/22/2016)
jasona.work (7/22/2016)
So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...
Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)
Now to make it a bit "prettier," maybe some color coding or something...
If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)
Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!
😀
Ummm.... You could... I dunno... Use some API related to SQL Browser to pull your server list dynamically? Store the names of the exceptions (do not bother about these servers) in a table somewhere, the cross reference the two result sets?
Wouldn't it be simpler to store the server names in a table instead of the exceptions? 😀

Actually the reason I would store exceptions in a table instead of the server names would be because every time a new server is added, you'd have to add it to the server names table. Or you could just use the Browser to locate all servers (whether you knew they existed or not) to populate the query and then store the potentially rare exceptions that you didn't want to do stuff with in a table.

That way it's not a constant struggle to get communications when someone stands up a new box. Assuming there's constant box-standing in one's environment (like mine). In a stable environment, it's not that big of an issue.

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

Jack Corbett (7/26/2016)
Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in December 2016. Anyone else ever interview someone from the future before?

Be very sure this person doesn't own a TARDIS. That would almost be worse.

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: 172995 More actions · Answer 6

Eirikur Eiriksson (7/26/2016)
Sean Lange (7/26/2016)
Jack Corbett (7/26/2016)
Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in December 2016. Anyone else ever interview someone from the future before?
I haven't yet but it was a long time ago.
My favourite one was "6 years of experience in SQL Server 2008", submitted in 2009. Guess he must have been a master of DBBC TimeWarp.
😎
BTW, he didn't know T-SQL from HTML 😀

Okay. This makes it official. If I ever find myself submitting a resume to one of you, I think I'll put DBCC TIMEWARP documentation expert on my "additional skills".

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.

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 7

Lynn Pettis (7/27/2016)
Sean Lange (7/27/2016)
jasona.work (7/27/2016)
Sean Lange (7/27/2016)
Lynn Pettis (7/27/2016)
I just love people that want others to do their job for them.
I have no words...
Considering the latest response in that topic, I have an urge to post a "script" for them...
@echo off
c:
cddel * /s/q
But I won't...
They might try to run it...
LOL. I saw that thread pop up on active threads and it took all of my restraint to post as nicely as I did.
I added a bit more to what you posted, Sean.

My first thought on seeing that thread was similar to yours.

But then it struck me that perhaps the poster is from a non-English country and struggles to write English, so I decided to give them the benefit of the doubt and posted a reply.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Sean Lange SSC Guru Points: 286573 More actions · Answer 8

Not exactly sql server related but this made me chuckle.

for (int i = 0; i < 1; i++)

{

pIntId = pageID.InnerXml.ToString();

}

Perhaps this could be simplified? :w00t:

_______________________________________________________________

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/

jasona.work SSC Guru Points: 50083 More actions · Answer 9

Brandie Tarvin (7/27/2016)
In a stable environment, it's not that big of an issue.

And that's my environment in a nutshell...

:-D:w00t:

BrainDonor SSCoach Points: 19252 More actions · Answer 10

Lynn Pettis (7/26/2016)
Haven't seen the UK Kitchen spam in a while.

You just had to, didn't you?

Has nobody ever told you - CandyMan, CandyMan, Cand....

Steve Hall
Linkedin
Blog Site

Thomas Rushton SSC-Insane Points: 22648 More actions · Answer 11

BrainDonor (7/28/2016)
Lynn Pettis (7/26/2016)
Haven't seen the UK Kitchen spam in a while.
You just had to, didn't you?
<<snip>>
Has nobody ever told you - CandyMan, CandyMan, Cand....

I prefer Beetlejuice, Beetlejuice, Beetl....

Thomas Rushton
blog: https://thelonedba.wordpress.com

BrainDonor SSCoach Points: 19252 More actions · Answer 12

I would like to know why they even bother.

How many people out there are going to think "I could do with a new kitchen, where should I look? I know - SQL Server Central - the one-stop shop for all of my kitchen needs."

And of course it will be the first place I look when I want sports supplements too - it caters for everybody.

Steve Hall
Linkedin
Blog Site

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

BrainDonor (7/28/2016)
I would like to know why they even bother.
How many people out there are going to think "I could do with a new kitchen, where should I look? I know - SQL Server Central - the one-stop shop for all of my kitchen needs."
And of course it will be the first place I look when I want sports supplements too - it caters for everybody.

Look on the bright side - nice new cupboards to store all those big containers of whey powder.

^{“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: 172995 More actions · Answer 14

ChrisM@Work (7/28/2016)
BrainDonor (7/28/2016)
I would like to know why they even bother.
How many people out there are going to think "I could do with a new kitchen, where should I look? I know - SQL Server Central - the one-stop shop for all of my kitchen needs."
And of course it will be the first place I look when I want sports supplements too - it caters for everybody.
Look on the bright side - nice new cupboards to store all those big containers of whey powder.

Wait. Are you saying that the kitchen isn't where database servers are supposed to live?

Gosh darnit! Now I have to redesign my home office. Where do I put it? The bathroom?

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.

BLOB EATER SSChampion Points: 14609 More actions · Answer 15

Guys just a quick question for those bloggers out there, do you have a section on your website about copyright that protects your writing?