Are the posted questions getting worse?

Question

Are the posted questions getting worse?

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

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

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

Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.

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

WayneS SSC Guru Points: 95460 More actions · Answer 2

yb751 (10/29/2015)
Ed Wagner (10/29/2015)
yb751 (10/29/2015)
I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)
I was thinking about unleashing it but then I thought maybe it was too much.
Could have called it 2 easy steps to forum happiness! I don't know what do you guys think? lol
It might be a bit much, but I know what you mean. It makes things so much easier to read.
I think the (sometimes arduous) task of getting people to post DDL, consumable sample data and expected output is more of a hindrance to being able to help people. The excuse of proprietary table design and PII is old. Table designs are just designs and I don't know what's confusing or ambiguous about the term sample data.
I admit that I'm quicker to help if someone takes the time to create a good post and actually asks a question.
Agreed...the main reason I hesitated was because it's hard enough getting DDL or sample data (which is way more important), that also asking for some formatting/prettification might be approaching wishful thinking territory.

Okay, I'm late, but I'm going to respond anyway.

I find that as you take the time to take your problem into generic, basic, reproducible code, you tend to find the answer for yourself.

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

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

WayneS (11/3/2015)
yb751 (10/29/2015)
Ed Wagner (10/29/2015)
yb751 (10/29/2015)
I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)
I was thinking about unleashing it but then I thought maybe it was too much.
Could have called it 2 easy steps to forum happiness! I don't know what do you guys think? lol
It might be a bit much, but I know what you mean. It makes things so much easier to read.
I think the (sometimes arduous) task of getting people to post DDL, consumable sample data and expected output is more of a hindrance to being able to help people. The excuse of proprietary table design and PII is old. Table designs are just designs and I don't know what's confusing or ambiguous about the term sample data.
I admit that I'm quicker to help if someone takes the time to create a good post and actually asks a question.
Agreed...the main reason I hesitated was because it's hard enough getting DDL or sample data (which is way more important), that also asking for some formatting/prettification might be approaching wishful thinking territory.
Okay, I'm late, but I'm going to respond anyway.
I find that as you take the time to take your problem into generic, basic, reproducible code, you tend to find the answer for yourself.

I know that statement is absolutely true for me. Once I get so far "down the rabbit hole" and start to lose where I am in the maze, taking a step back and breaking down what I'm working on generally tends to help clear things up. It also helps to deescalate the frustration factor that comes up from time to time.

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

WayneS SSC Guru Points: 95460 More actions · Answer 4

BL0B_EATER (11/3/2015)
Going to PASS is on my list of objectives but due to lack of company interest in me I cant afford it as I have decided to go to IE2 instead, but I am still very curious about it. Can someone tell me what the difference is between Pre-Conference Sessions & "normal" Conference Sessions ??

A precon is an in-depth all day dive into one specific topic by a specific set of speakers (frequently just one, but there will be some that have a team of speakers there).

Normal conference sessions are just shorter (60/75/150 minutes).

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

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

ChrisM@Work (11/3/2015)
Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.

No spare time this week, but given the cost impact of getting it wrong, he may want to get someone in to help design it, rather than relying on free help.

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

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

GilaMonster (11/3/2015)
ChrisM@Work (11/3/2015)
Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.
No spare time this week, but given the cost impact of getting it wrong, he may want to get someone in to help design it, rather than relying on free help.

Yep, excellent point. Thanks Gail.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

rodjkidd (11/3/2015)
SQLRNNR (11/2/2015)
Grant Fritchey (11/2/2015)
rodjkidd (11/2/2015)
Really good summit.
My lasting memories will be;
The Threadizens taking over one of the birds of a feather tables (don't tell anyone), and the photo!
Gail's hat for ArgenisWithOutBorders - I have photos I will start up loading tomorrow or Wednesday once I get home... Slight detour to Birmingham... As you do... Oh OK just me then!
Meeting the legend that is Lynn Pettis and having a really good chat with him.
Rob Farley knowing who I was!
Seeing and chatting to Kalen Delaney at least once each day... I think I have only met her 2 or 3 times before. Rob had to tell her who I was - So a double whammy in one go, who know Rob knew my name hehe...
The 'Escalator incident' - Grant knows all about that
Rodders...
Who knew there was instruction needed on proper escalator operation? I'll submit an abstract for the next Summit.
*COUGH*
Who knew you didn't have to actually press the emergency stop button to cause it to stop?
I was travelling in one direction, I just changed that direction! :O
Rodders...

hahaha

The emergency stop happens to be another incident at summit I witnessed.

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 8

GilaMonster (11/3/2015)
ChrisM@Work (11/3/2015)
Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.
No spare time this week, but given the cost impact of getting it wrong, he may want to get someone in to help design it, rather than relying on free help.

My thought exactly!

😎

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

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they don't know what they don't know. I'm not asking difficult questions so far because none have gotten that far, yet.

No takers on the job description I posted a while back?

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

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

Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?

Wrong country.

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 11

Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?

Remote working an option?

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 12

GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.

and wrong state

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 13

Steve Jones - SSC Editor (11/4/2015)
GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.
and wrong state

Ditto. Plus, I'm not entirely qualified, much as I might wish I was. I'm sure I could learn it, but it sounds like you guys want someone who will hit the ground running.

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.

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

anthony.green (11/4/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Remote working an option?

Unfortunately, probably not for this one, Anthony. I will ask, though. Where do you call "home"?

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

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

GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.

For sure. The boss there would love what you can do, Gail.

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