Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,926 through 20,940 (of 66,815 total)

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

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 1

Craig Farrell (10/27/2010)
So, you want fresh topics in that forum, rather then responses to the pinned topic? Just confirming from what I see. When I read the pinned item it seemed more simplistic.
Nice idea though, should get some value there.

Respond to individual posts. I'll close as someone gets the topic.

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 2

Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try to pick things you see a couple times in the forums.
http://www.sqlservercentral.com/Forums/Forum2824-1.aspx
As a side bar, I notice you were able to pin a post at the beginning of the new forum. It would be really cool if you could pin a post with links to the two forum "How to post/etiquette" articles by Gail and myself.

pin a post in that forum? Or others? Don't want to pin in every forum.

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Steve Jones - SSC Editor (10/27/2010)
pin a post in that forum? Or others? Don't want to pin in every forum.

Shame you can't have those two links just be immediately clickable as soon as someone hits 'Add Topic' in the editor window. I'm all for them being pinned in every forum, though... :w00t:

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 4

Steve Jones - SSC Editor (10/27/2010)
Jeff Moden (10/27/2010)
I'll be happy to do the "Ordering months by number" thing. Like Lynn says, though, it would really be helpful if we knew what the original post was, if possible.
Not sure where it is, but I've seen it a few times this year and dropped it on a list. People for some reason don't get the datepart/datename thing. a simple one pager, make up a common example, would suffice. Some code, explain how the functions work, the ordering, etc.

Ah... THOSE problems! I know exactly what you're talking about.

We need a catchy category name for these types of articles. You mentioned you wanted to "fill holes". How'z about "SQL Spackle" for a name? Something like "Helping fill the cracks in code." could be used for a tag line.

If you wanted a small jingle... (sung to the tune of "Row, Row, Row Your Boat")

No, no, no you won't,

Loop with any class,

Merrily, merrily, merrily, merrily,

Set-Based saves your ___! 😛

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

Craig Farrell (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
pin a post in that forum? Or others? Don't want to pin in every forum.
Shame you can't have those two links just be immediately clickable as soon as someone hits 'Add Topic' in the editor window. I'm all for them being pinned in every forum, though... :w00t:

I was kind of hoping to have them pinned in at least the General, TSQL, Newbie, and Performance related forums.

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

Paul White SSC Guru Points: 150468 More actions · Answer 6

Jeff Moden (10/27/2010)
We need a catchy category name for these types of articles. You mentioned you wanted to "fill holes". How'z about "SQL Spackle" for a name? Something like "Helping fill the cracks in code." could be used for a tag line.

I don't get the SQL Spackle reference, but if the author should definitely be shown as Phil McCracken 😎

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 7

Here's what I quickly came up with to act as both the introduction to the article and the "teaser" for the news letter for the "Ordering by Months" article...

[font="Arial Black"]SQL Spackle: Ordering Months By Number[/font]

[font="Arial Black"]Introduction:[/font]

[edit] I took the "teaser" down from this post because I changed it in the final article and didn't want anyone to accidently copy the wrong one.

Of course, "SQL Spackle" might not be what you folks want for the category name. Maybe a take off on the old "You asked for IT" show (play on "IT") or something similar. You folks make some more suggestions and we'll have Steve pick one. Please, no reference to kilts or Grant's legs as a category. 😀

--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: 1004641 More actions · Answer 8

Paul White NZ (10/27/2010)
...the author should definitely be shown as Phil McCracken 😎

Now THAT's entertainment! 😀

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

WayneS SSC Guru Points: 95461 More actions · Answer 9

Steve Jones - SSC Editor (10/27/2010)
BTW, SSC usually has a blogger at the blogger table during the PASS Summit. Usually it's me, someone that can take notes during keynotes and post them. Since I won't be there....
any of you rapid posters want to lug a laptop to the keynote each day and take some notes and post a blog? One a day is fine, more are better, but up to you.
Ping me if you want the spot.

You paying my way there? :w00t::-D

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

WayneS SSC Guru Points: 95461 More actions · Answer 10

Paul White NZ (10/27/2010)
I don't get the SQL Spackle reference...

http://en.wikipedia.org/wiki/Spackling_paste

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

WayneS SSC Guru Points: 95461 More actions · Answer 11

Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try to pick things you see a couple times in the forums.
http://www.sqlservercentral.com/Forums/Forum2824-1.aspx

I'd also recommend, if possible, posting link(s) to the forums that prompted the request.

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

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 12

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in the "Write for us" link so you don't have much to do to put it out there.

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

WayneS SSC Guru Points: 95461 More actions · Answer 13

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in the "Write for us" link so you don't have much to do to put it out there.

@steve-2, if you want to go with "SQL Spackle" and/or "Phil McCracken", I'll modify the article I've sent to you.

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

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

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in the "Write for us" link so you don't have much to do to put it out there.

Just to clarify... I let "Phil McCracken" make the statement about what the SQL Spackle series was. I signed the article at the end. We can change that if everyone would like. We can turn "Phil" into a real hero. The problem is what Wayne pointed out in a PM to me... I have a very unique writing style and I think everyone would know which ones I wrote.

I've already submitted my article via "write for us" but I can certainly change it.

--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: 104768 More actions · Answer 15

Jeff Moden (10/27/2010)

If you wanted a small jingle... (sung to the tune of "Row, Row, Row Your Boat")

You shouldn't mention that in an SQL forum: "Row" is unspeakable, think of columns and sets instead. :hehe:

Tom