SQLServerCentral / SQLServerCentral.com / Suggestions

Briefcase

digitalox — Sun, 22 Nov 2009 10:35:59 GMT

I think it'd be useful to be able to add forum posts to our briefcase too, if that's possible. With so many good problems solved in there, it'd be great to save them for future use all in one place alongside the articles/scripts.Thanks,Scott

SSC Level List?

Chad Crawford — Fri, 25 Jan 2008 13:42:51 GMT

OK - I know this is SO insignificant, but I get a real kick out of moving from level to level. I'm very careful about the QOD and try not to miss any points (CURSES for the 40 point question I guessed wrong on!), and post replies when I have a chance. I live in awe of the SSCrazy team and dream about some day being worthy enough to be considered "Chasing Mays". I know the level is no where near as important as posting well though out, quality responses in the forum but I still find myself wondering what and where the next level is. Any chance of posting the levels and values?

Vet a QOD?

Chad Crawford — Tue, 27 Oct 2009 11:05:18 GMT

I was working along today and ran into something interesting with SQL Server that I didn't know before. It's not obscure or only limited to specific environments or rarely used features (everyone does a LEFT JOIN, right?), so I think it would have a broad base of interest and is an excellent candidate for a QOD. However, there are some technical pieces that could really burn me, specifically if this optimization is only valid for specific editions or versions, so I'm hesitant to submit the QOD since I haven't done complete research and would probably miss something anyway even if I tried.So... What do YOU suggest? There really isn't a forum to submit a QOD for review prior to submitting it, and if there was, would that be giving away too much (I don't think so - it's easy enough to cheat on the QOD if that's what you want anyway)? Do I submit it and put on my thick alligator skin, or are there enough QODs already and I just keep it in my gee-whiz file?

Merge 2005, 2008 into one forum instead of separate ones?

Maxer — Tue, 20 Oct 2009 08:37:46 GMT

Just a suggestion:Maybe merge all the forums about different SQL versions into a single one.So just TSQL instead of TSQL for 05 and 08 and some day 2011 or 12 or whatever the next version is.Instead perhaps just a single forum and then when you post you could have a drop down box that lets you pick which version you are talking about.www.utteraccess.com does that for its Access posts and it seems to work well IMHO.It would just make it easier to follow all the threads, and most things don't differ THAT much between versions.But if I'm using SQL 05 only I may not read the 08 forums and vice versa so people may be less able to read and post due to a divided readership focus.Also... it just seems wrong to not have those tables normalized!;)

Dark Forum Skin

Garadin — Tue, 06 Oct 2009 20:22:28 GMT

The all white is super bright for late night reading. Any chance at a dark/black skin option?

Downtime for the forums

Silverfox — Tue, 22 Sep 2009 05:18:35 GMT

Seems to be a lot of posts atm, talking about how slow it can be, when either replying to posts or viewing the forums in general.I know that there are scheduled times that either data feeds are either going on, or database maintenance tasks are running.Could we have a pinned topic, which basically said by timezone when the site will be not running at full speed.for me in the mornings,based in the UK, I know that I will have issues with trying to post any replies. If I knew that between 8am -9am GMT for example, there are jobs running, I can take into account any delays without getting annoyed about it.you could list the times that things ran, and you could put all the different timezones, so people wouldnt have to post so much about it and we might also limit the number of duplicate posts that we are getting at times.

TEST

Dugi — Thu, 17 Sep 2009 06:17:50 GMT

Just for test!

Editorials page

matt stockham — Thu, 10 Sep 2009 09:28:07 GMT

Each day I come to the site I look over the new articles and then go to the Editorials page to see the latest. Lately I've been greeted with more than a whole page of tags, most of them with a single entry. I realise that this comes down to me being too lazy to want to scroll down, but is there any chance of moving or removing some of these tags?

Separate Forum for I want to be a DBA topics

Silverfox — Tue, 01 Sep 2009 10:10:07 GMT

Practically every day there are loads of I want to be a DBA, the same replies are hashed and rehashed, it is like a continual deja vu every day and in different forums as well.Can me have one place where all the nice editorials and articles about becoming a DBA are pinned. with even a topic for suggestions of what people are always looking for, so they can be added as time goes on.

Separate Reporting Services 2005 and 2008.

checkai — Mon, 31 Aug 2009 07:18:49 GMT

Separate Reporting Services 2005 and 2008Thanks,DLC

Mark as Answer and Collect Pointers

Mani Singh — Thu, 20 Aug 2009 10:27:27 GMT

How about letting the poster, mark a couple of suggestions as answers that will change its color or something.. also let the forumn poster collect imp points from the answere.. He/She should be able ot select the line/word and righ-click as Take Pointer.. which will be accumulated in this forumn post as valuable pointers to this Question.. so the users in Future can reference those first insted of browsing through all the posts....

Add fields to email notification

crookj — Wed, 05 Aug 2009 09:05:55 GMT

Steve,Can you add the date/time field of posting a response and the forum topic to the body of the email notification?Thanks,Joe :cool:

what does return from a CRUD store procedure

fausto usme — Wed, 05 Aug 2009 14:58:51 GMT

Hello everybody i need help.I have a store procedure to make a CRUD to a table.My question is about of how must i return the data when is just a data orwhen is a set of data.Is like dynamic return, i don´t know, i hope be clear.thanks a lotfausto

I broke it. Can you fix it, please?

Jeff Moden — Sun, 26 Jul 2009 09:49:53 GMT

Please take a look at the following... I quite unintentionally broke a code window which pretty much made a thread useless.[url]http://www.sqlservercentral.com/Forums/Topic759734-433-1.aspx#bm759774[/url]My suggestion would be that while the code windows are real pretty and all, I'm not so sure that "color" is worth it. I know it takes time to hammer stuff like this out, but it's been a real PITA for folks like me and I'm sure you're getting tired of hearing about it from me. There's been lots of threads that popup a message about a script taking too long... it would appear that it's the colorizing script because when I say to stop running it, the "old" light purple (how I miss those now!!!)) code windows display.

auto subscribe the author to the forum posting

Lowell — Tue, 28 Jul 2009 07:47:57 GMT

maybe it's just me, but it seems that I just noticed that if you contributed an an article or a script, a forum posting gets automatically created...but the author of the posting doesn't get any automatic notifications of any replys to that thread.I just found where someone posted a follow up question from 5 months agao to one of my scripts i submitted...I felt bad following up so much later.also, postings to those "Article discussions By Author" threads do not appear in the recent posts, but I figure that is by design, right?

This is just a test of something

Derek Dongray — Wed, 15 Jul 2009 17:53:21 GMT

So say we have some SQL which was manipulating HTML...Select x + '' from somewhereWould the forum code pick it up?(Preview looks really weird so the answer is no!)

SQL Architecture Articles

Chand00 — Tue, 07 Jul 2009 07:23:10 GMT

Hi, I did not find any articles related to sql server 2005 architecture here. Even in the forums when a user ask about the sql architecture I had seen replies that ask the user to refer BOL. But why dont we have an article which explains sql server architecture. Because most people rely on SSC rather than BOL and in BOL it is difficult for a newbie to understand the architecture.

Adding forum topics to briefcase

ChiragNS — Tue, 24 Mar 2009 00:02:01 GMT

HiIs there any way by which forum topics can be added to briefcase?

Article Download

Charlie.anna — Fri, 05 Jun 2009 05:23:45 GMT

Dear RedGate.Thanks a ton for running such a great community for SQL Server, this is a great place where newbie,experts and even master can find something new related to Database technology.I am almost a regular visitor of the sites and I believe that every body need to save some of the codes, articles for future references, currently I am doing this by copying and pasting into document file in my laptop.Is it possible to make articles downloadable in doc/pdf formats? this the only great facility missing in this community.With Warm Regards,Ravi

Code Shortcuts

Steve Jones - Editor — Tue, 16 Jun 2009 09:14:13 GMT

when you post, I think a number of you notice there is a list of shortcuts to the left of the text box. This is not the complete list, for the complete list, there is an "IFCode" button above the text box.If there are heavily used codes, please post here and I can add them to the list on the left.

Ratings breakdown

WayneS — Wed, 10 Jun 2009 18:56:35 GMT

Steve,Would it be possible to get a breakdown of the ratings? How many for each rating, with a total?

Sort by Reads or Ratings

Jason Crider — Tue, 09 Jun 2009 08:06:26 GMT

How difficult would it be to have a section for scripts that would allow you to do a sort by rating, reads, or date? What about the same thing for articles?It would be so much easier to find something really great that you might have missed otherwise.If this feature is somewhere and I've missed it please let me know.Thanks for keeping up a great site!

Unsubscribe from Topic

Christopher Stobbs — Tue, 14 Apr 2009 07:56:58 GMT

Hi,Is it possible to unsubscribe from a topic when viewing the topic.I find it a mission to got to my control panel and have to go through all the topics to unsubscribe that way.It would be nice if we could do this from the topic options of each topic .thanksChris

SQL Server versions in use in the production environment

David.Poole — Thu, 23 Apr 2009 04:21:16 GMT

I am trying to guage how many people are still using SQL2000 or even earlier versions given that Microsoft ended general support for SQL2000 in April 2008.

didn't receive daily email today

ppcx — Wed, 25 Mar 2009 10:04:28 GMT

I don't know if this is the right place to mention this, but I didn't receive my daily email from sqlservercentral today. I've looked all through my gmail account but don't see it anywhere. Has anyone else indicated they had problems today too?

Active Tasks and Recent Posts not worikng Right...

RBarryYoung — Thu, 19 Mar 2009 23:16:58 GMT

Active Tasks always shows 121 threads across 4 pages now.Recent Posts..Posts Since Last Week, always shows 150 across 4 pages.I have tried changing my settings without any luck.

SQL Server 2008 build list?

AlanBarber — Mon, 16 Mar 2009 18:23:34 GMT

Are there any plans to keep a running build list for 2008 like you have done for 2005?thanks!

Not a suggestion per se but wasn't sure what forum to use

tosscrosby-60625 — Fri, 13 Mar 2009 06:14:30 GMT

On Lynn's article, it showed the following stats. Am I missing something? 13.4K total article views, 2.2K in the last 30 days but it was posted on 3/13/09 - something has gone haywire methinks....or is it due to being Friday the 13th? :w00t:Calculating AgeBy Lynn Pettis, 2009/03/13 Total article views: 13392 | Views in the last 30 days: 2211

"Answered" Posts

Unknown. — Mon, 02 Mar 2009 01:45:39 GMT

Hi,How about adding "Mark As Answer" feature?Where The thread starter or a Moderator can mark a post as answer to the more correct or more helpful reply.It will help in great deal - Someone who is searching for similar problem- Rating for Answerer'sAlso I don't like the current points system at all. The points merely suggest quantity participation of a member and NOT quality. Almost all other Online forums already have such feature.

Books ( great Link )

Dugi — Wed, 18 Feb 2009 02:20:05 GMT

Hi Steve,I saw the updates on Books link...and for very interesting was the volumes from SSC so you added the vol 5 and 6 ...can you upload from 1-4 also!? They have very good stuff of SQL! I like them it would be much appreciated if you upload them!Thanks!Dugi :hehe:

Suggested poll for SQL version Type

john.peters — Wed, 04 Mar 2009 16:58:25 GMT

SteveYou asked for who was using SQL 2008 ?Can you add a Poll so we could just click on the various iterations of SQL and then it can automatically do the donley work for you !:D

XML Tags and data inside gets vanished

Unknown. — Wed, 04 Mar 2009 09:37:57 GMT

Hi,When I try to post some XML tags they get vanished, also the data inside it.Is there I'm missing something or it is known issue on the forums?Now a days XML queries are widely used. Very much required to post them for some solutions.See I included some them in this post, but can't seem to find them. [code] [/code]

Answered Posts

Unknown. — Wed, 04 Mar 2009 06:51:14 GMT

[code] blocks not respecting line feeds all of the sudden

Lowell — Mon, 23 Feb 2009 11:19:21 GMT

all of the sudden today, code that i paste between {code} {/code} blocks (with square brackets) are losing their CrFl--newline whatever in them;anyone know if there was a change to the editor?if i preview before posting, it looks fine, but the final post loses then:example:--for users who are too lazy to type "SELECT * FROM" CREATE procedure sp_show --USAGE: sp_show gmact @TblName varchar(128) --WITH ENCRYPTION As Begin exec('Select * from ' + @TblName) End [code]--for users who are too lazy to type "SELECT * FROM" CREATE procedure sp_show --USAGE: sp_show gmact @TblName varchar(128) --WITH ENCRYPTION As Begin exec('Select * from ' + @TblName) End [/code]or [code][font="Courier New"][size="2"][color="green"]--for users who are too lazy to type "SELECT * FROM" [/color][color="blue"]CREATE PROCEDURE [/color][color="darkred"]sp_show [/color][color="green"]--USAGE: sp_show gmact [/color][color="#434343"]@TblName [/color][color="blue"]VARCHAR[/color][color="gray"]([/color][color="black"]128[/color][color="gray"]) [/color][color="green"]--WITH ENCRYPTION [/color][color="blue"]AS BEGIN EXEC[/color][color="gray"]([/color][color="red"]'Select * from ' [/color][color="gray"]+ [/color][color="#434343"]@TblName[/color][color="gray"]) [/color][color="blue"]END [/color][/size][/font][/code]

Search results

Jim Russell-390299 — Fri, 05 Sep 2008 05:48:53 GMT

Is there a way to:1. Restrict a search to a single Forum topic?2. Select the result order (by descending date would help)?3. List just the postings the user has made?4. Have new posts (not just those that have had replies) show up in the daily summary email?Thanks!

Customize "Active Threads"?

Derek Dongray — Fri, 13 Feb 2009 05:47:05 GMT

Is there some way to change the number of topics per page on "Active Threads"?I also noticed that the ordinary "Advanced Search" can't reproduce "Active Threads" because it refuses to do the search if there are no keywords.

How do I resubscribe?

andrew.mcgrath — Wed, 11 Feb 2009 15:01:04 GMT

Well I wanted to change my email address, the only way from the daily newsletter seemed to be to unsubscribe.To help stop the site from running out of integers in it's quest to get all 6 billion citizens on the planet on the list.....I would like to resubscribe to the daily newsletter without having to create a new account...How do I do this?Andrew

Backslash-n

Jim Russell-390299 — Thu, 20 Nov 2008 12:31:49 GMT

I noticed in a current thread that attempts to describe a line termination sequence (like a VBCRNL, typed with backslashes (instead of the forward slashes used here) e.g. /r/n, the backslash-n gets edited out: For example, here is backslash-r backslash-n written with real backslashes:\ryet the backslash-n gets lost.I tried a few combinations of escape character prefixes with no luck; perhaps it would be preserved in a quote:[quote]\r[/quote]Nope, that does not help either.Is there a way to avoid this behavior?Just noticed that they were discarded in the original after using Spell Check. I put them back in before I posted.

The Incompetech name

JChwaszczewski — Fri, 12 Dec 2008 10:53:41 GMT

Sorry to be negative, but I find the prominent usage of "Incompetech" to be a drawback to the newletter. For me, it's too close to the word "incompetent" and invokes images of an "incompetent tech(nical)" person. If the word/brand/website has a history or association with SQLServerCentral I don't know what it is. Otherwise, I find the newletter informative and useful.

Views in the Last 30 Days

Lynn Pettis — Mon, 02 Feb 2009 16:17:53 GMT

As a guest author, I have noticed that it would be nice on our page that lists or articles if it would also list the number of views in the last 30 days as well as total views. You can get this info by opening up your own article, but then that also increments the number of views. I'd like to be able to see this without affecting the counts.