January 31, 2005 at 2:53 pm
I have lost count of the number of times the T-SQL forum has addresed the use of coalesce to create a comma-separated list from a column. There are probably a dozen or so similar questions that come up at least once a week, if not once a day. The problem statement then is to "provide a way to rmaintain and rapidly locate a very few high value posts as the first posts in a forum".
I have seen two possible solutions in other forums that might be useful here.
1) Based on user-ratings and feedback over time, add a flag to certain posts/threads that readily sorts to the top of the forum.
2) Create a single FAQ for each forum that has a set of links to the highest-value posts. The FAQ is then "stickied" as the first entry in every forum.
I favor the second option as it provides a clean mechanism, in a single post, to find what I am looking for most of the time. One of the difficulties of any such sticky solution is choosing which posts are worthy of including in the short list.
I'll shut up now. Your thoughts?
Have a great day!
Wayne
January 31, 2005 at 9:57 pm
Wayne,
An interesting idea. We'll take a look though I think this might take some development time and we've got a couple other irons in the fire.
Steve
February 3, 2005 at 3:10 pm
I agree. An interesting idea. But at the same time I think, it won't help much here. People seem to post to online communities (here or anywhere else) without even doing the most simple and easiest research that there is. That is press F1 on the keyboard. They obviously don't use the search functionality, so why should they bother reading a sticky topic?
Another point: The more sticky topics you have, the less current topics fit on the first page of a forum. Being a webmaster myself, this would be one thing I wouldn't like to see. I for myself have added one sticky topic in each forum. It contains a link to the rules of conduct, what to post to receive a good and quick answer and so on... So, personally I would favor the second option, if I had my way.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply