InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:37:11 GMT20http://www.sqlservercentral.com/Forums/Topic1305016-433-1.aspxWhy isn't this Mr. or [u]Ms.[/u] 500? Feels like I'm stuck in 1965....RichWed, 23 May 2012 08:46:36 GMTrmechaberhttp://www.sqlservercentral.com/Forums/Topic1264554-433-1.aspxHi, is there anyway to stop the e-mails that are sent when someone replies to your thread?Fri, 09 Mar 2012 11:54:02 GMTguerillaunithttp://www.sqlservercentral.com/Forums/Topic1300877-433-1.aspx[font="Verdana"]Hi Steve,Congratulations for great success story of SQLSERVERCENTRAL!May i request you to kindly add a new head in forums i.e. "Cloud Computing"to discuss1. Design (Database inter-dependence/interoperability)2. Future Trends3. All their related development and administration issuesHopefully you may consider the request with the idea to make it more realistic and concise one! Many thanks for hearing![/font]Wed, 16 May 2012 03:22:58 GMTAbrar Ahmad_http://www.sqlservercentral.com/Forums/Topic1299703-433-1.aspxit is very good sampel and toterial and scription in sitei am iranian and i very love sql and data mining .i love this siteMon, 14 May 2012 10:21:17 GMThamed.tavasolhttp://www.sqlservercentral.com/Forums/Topic1267644-433-1.aspxSearching Google I found an article, on this site, 'Custom Report Item - Part I' but when you enter 'Custom Report Item' into your search box.. nothing is found!Thu, 15 Mar 2012 10:26:52 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1283217-433-1.aspxI received a PM this morning with an attachment but whenever I try to view the attachment I receive the following error:[quote]Sorry the application encountered an unexpected error. Information about this error has been logged. If you continue to receive this message please contact the board administrator.[/quote]Fri, 13 Apr 2012 09:17:51 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic977659-433-1.aspxWhen adding some RSS feeds for forums to Google Reader I get "Permission Denied" for several of them (but not all!). Any idea? A few examples:Worked: 2008 General, 2008 T-SQLFailed: 2008 HAIt looks like :You have subscribed to "Permission Denied..""Permission Denied." has no unread items.Que desu?Mon, 30 Aug 2010 19:30:42 GMTramamhttp://www.sqlservercentral.com/Forums/Topic1266429-433-1.aspxI posted an script [url=http://www.sqlservercentral.com/scripts/Performance+Tuning/89143/]Get Top Queries Taxing SQL Server CPUs [/url] though if you copy that code and try to run in SSMS it does not due to lots of invisible characters added.Only way to see that character is to open notepad in windows 2003 (not 2008) or SQL2012 SSMS (not earlier versions)Link:http://www.sqlservercentral.com/scripts/Performance+Tuning/89143/Is this a known bug? anyone knows how to handle this?Tue, 13 Mar 2012 17:52:25 GMTPrakash Hedahttp://www.sqlservercentral.com/Forums/Topic1265340-433-1.aspxI often find forum comments made by a member that I would like to 'like' or give a 'thumbs-up' to. Is this an enhancement that might be considered?Mon, 12 Mar 2012 10:15:44 GMTseth delcontehttp://www.sqlservercentral.com/Forums/Topic1262290-433-1.aspxHi,I am trying to submit a script using the Contribution Editor. I have all of the fields populated, but the Sql Script box itself is greyed out and will not let me enter anything. I am not sure if I need to do anything else to be able to submit, but I can't figure out how to turn the textbox 'active'.Tue, 06 Mar 2012 08:53:29 GMTupstarthttp://www.sqlservercentral.com/Forums/Topic1257177-433-1.aspxJust an idea, and it might be something which has been raised before.The latest spamer ybz199009 is starting to wind a few people up, so my question is can an authentication put this word in this box kind of thing be put on the profile creation page to stop say automated bots just randomly creating profiles.Granted this wont stop people who are actually doing it manually but might reduce the number of threads which get hijacked allowing people to see what threads have be updated by people trying to help.Fri, 24 Feb 2012 01:04:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1253976-433-1.aspxHi AllNoticed a few people with an animated GIF avatar, yet when I changed mine to one it's not displaying the animation, just a static image.Any ideas?ThanksAntFri, 17 Feb 2012 09:17:12 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1251393-433-1.aspxI keep trying to send a message to a user, Dev, by clicking on his name and going to "send private message." However, it keeps going to a different user with the name Dev. Is it possible that there is a duplicate in your database that is causing this issue?Mon, 13 Feb 2012 11:38:11 GMTSQLKnowItAllhttp://www.sqlservercentral.com/Forums/Topic1251518-433-1.aspxI'm seeing a lot of posts that were applied to the SSC Blogs appear in batches in the Forums Recent posts>>Posts Added today, and I'll throw my two cents in...they don't belong there.Blog posts always vaguely anonymous: [i]Discuss Content Posted By Unknown Unknown[/i] with [i]Last Post By Site Owners[/i]I 100% understand the purpose of it is to attract interest, but I find it distracting and the two things that bug me are really basic:the posts should be able to harvest the blog owners name or nickname; Unknown Unknown might as well be NULL NULL.The come over in batches it seems; it can push forum questions off into page two of 4 when it occurs, which can be annoying on active forum days.[img]http://www.sqlservercentral.com/Forums/Attachment10855.aspx[/img]Mon, 13 Feb 2012 14:11:52 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1250619-433-1.aspxhow do you turn off the e-mail notifications that alert you when someone posts a reply to a topic that you've active in?Fri, 10 Feb 2012 16:51:28 GMTguerillaunithttp://www.sqlservercentral.com/Forums/Topic1241805-433-1.aspxtypically i get emails from threads I've subscribed to or participated in pretty quickly after they are replied to, but the last two days they've been severely delayed or never received at all, even though i see the thread, and it's updates later in the day.the issue's pretty much in two places (I'm excluding the Chair-To-Keyboard-Interface for arguments sake :-P ) my email server, which is always a possibility, or maybe SQL Server Central, which must have to pump out a hundred thousand emails a day to it's 1.3+ million members.is anyone else seeing the same issue, or should I kick off a complaint to my hosting service, which does the email stuff?Wed, 25 Jan 2012 14:47:55 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1239258-433-1.aspxOn todays home page is an article entitledSub query expressions vs. Joins.By Brian Ellul, 2012/01/20 (first published: 2010/07/22) http://www.sqlservercentral.com/articles/Table+Spool+Operator/70583/The article is interesting, but the real value comes in the discussion afterwards.(actually Jeff Moden adds a bit to the discussion and totally turns it around)My question is, can SSC do more guide people to the discussions on republished articles?IanFri, 20 Jan 2012 02:51:41 GMT440692 I am just a numberhttp://www.sqlservercentral.com/Forums/Topic1235628-433-1.aspxRight now I can't seem to find a way to set my default thread subscription to none.More often than not, I don't want reply notification emails so I have to go back into my properties and unsubscribe after every post I make.Is that an option that I'm missing or is it not a feature?Fri, 13 Jan 2012 07:18:18 GMTcalvohttp://www.sqlservercentral.com/Forums/Topic1220379-433-1.aspxI've attempted several times to change my email address but never receive the change email to confirm.Help. :-)Mon, 12 Dec 2011 10:26:57 GMTJason Selburghttp://www.sqlservercentral.com/Forums/Topic1218648-433-1.aspxHas SSC considered developing its own competency tests/quizzes for sql developers, dbas, or SQL Server in general?I'm not talking about anything like a certification or certification prep, just a set of questions that would reveal areas of strength and weakness.The primary purpose would be to show individuals where or how they might best spend their time improving their skills. Not only could this improve the general pool of talent available to employers but it could also assist the unemployed by making them more competitive in the job market. Lastly, it could help those who are considering becoming data professionals (Do I know as much as I should to begin seeking employment in this field?).Just a thought. I think your organization would do it very well.Thu, 08 Dec 2011 08:14:02 GMTjshahanhttp://www.sqlservercentral.com/Forums/Topic1197470-433-1.aspxI try to submit a script.But when I paste the code it's displayed as 1 line.Tried to copy/paste it from SSMS, notepad, MS Word,... but always 1 lineHow can I properly paste my code (readeable) before I publish it?Fri, 28 Oct 2011 07:15:10 GMTRhoxhttp://www.sqlservercentral.com/Forums/Topic1173945-433-1.aspxHi,Is it possible to sort out the tab spacing when posting code with [code=sql][/code] tags? When you go to the trouble of laying out your code properly to make it readable, it is a bit irritating to see it mangled to death on display!Thanks, IainTue, 13 Sep 2011 02:12:52 GMTirobertsonhttp://www.sqlservercentral.com/Forums/Topic1171507-433-1.aspxSSC ought to have LinkedIn and Twitter URLs in the Contact Details | Web Presence section of a user's profile. With appropriate links on their posts like is done for blog/www.Wed, 07 Sep 2011 22:04:24 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1160408-433-1.aspxit would be great to see the forum on taptalk so that it can be available on the iphone. see http://www.tapatalk.com/ for details on how easy it would be to integrate the forum with this great capability.Tue, 16 Aug 2011 02:15:51 GMTwayne.theronhttp://www.sqlservercentral.com/Forums/Topic1157795-433-1.aspxWhen looking at a article with blue code boxes using an Iphone, the blue code boxes are sometimes too narrow to fully show the code lines. As there are no scroll bars it is impossible to see the full code. Is this possible to fix?Wed, 10 Aug 2011 10:11:36 GMTmaccer83http://www.sqlservercentral.com/Forums/Topic1155486-433-1.aspxHi Steve,I tried several times to publish a new blog, after log into my "dashboard control panel", I can write a post, but I cannot Preview it and also when I click "Save and Continue writing", the original body part will be blank. When I tried to publish it, only the blog title can be seen. I was doing this at around 12:30am Aug 6, PDT.Does anyone use windows live writter to publish blog directly to SQLServerCentral blog site?Thanks,Jeffrey YaoSat, 06 Aug 2011 02:31:32 GMTjeffrey yaohttp://www.sqlservercentral.com/Forums/Topic1147442-433-1.aspxChaps, it might be me, but I'm sure most of the articles in the 'Stairway to Integration Services' series are missing.I've left it a while to read them from when I got the alert emails for them, but I'm sure there were 5 or 6 parts and I only see the first two on the site. And article 2 mentions article 3 which doesn't appear to be there.Does anyone know where they are?Mon, 25 Jul 2011 06:41:31 GMTTwilight Turniphttp://www.sqlservercentral.com/Forums/Topic1136895-433-1.aspxIt would be nice to get a single BI main heading that would contain SSIS, SSAS, SSRS, DW Design and perhaps break it down by version 2005 and 2008 So a total of 7 forums under BI.Currently there is a BI forum under SQL2005, an SSIS forum under 2005, an SSIS forum under data warehousing, and there is a lot of BI postings under SQL2008 general. It would be nice to have a single location that everyone uses for BI stuff.ThanksTue, 05 Jul 2011 16:21:19 GMTTom Van Harpenhttp://www.sqlservercentral.com/Forums/Topic1137622-433-1.aspxJust FYI that your last newsletter was totally blocked in our Exchange System by our mail filter for offensive language for the XXXs in the SQL Server 2005 Development "Different Query Requirement" example... Might want to watch those for future editions so we get the newsletters... :rolleyes:Wed, 06 Jul 2011 13:43:08 GMTreskerhttp://www.sqlservercentral.com/Forums/Topic1136451-433-1.aspxTo the Editorial staff:I have a simple request, ( and at the risk of sounding selfish ), I just have to put it out there: Is it possible that the focus of future articles, could somehow be focused on a more in-depth explanation of whatever the subject is?I mean, after about 5 years of subscription to this news magazine, the primary focus is for articles aimed at Newbies, which, I am willing to bet, that more experienced DBAs scoff at. Even first-year, or second-year DBAs, or Newbies get this info from books, BOL, etc., already, and QotD doesn't cut it, buddy! I don't know anything about running news magazines, but it seems obvious that a larger part of your audience is more advanced that these "Introductory" articles. The Briefcase feature is probably the only reason DBAs use this news magazine.Relational Database is not rocket science, if it ever was, and there are new converts coming into the field, but, what about the bulk of your audience? Now, I am not a Writer, ( so stop looking for articles from people like me ), the MVPs in the Blogs could be a good place to start.I am not saying I know everything about databases, but, every time I see an article about "an introduction to Indexes", it makes me want to puke. I feel like I need a shower every time I read a "New" article about some familiar-sounding topic, and, hoping for something to add to my vocabulary, my knowledge-base, I am always disappointed, because, it stops short, of any new or challenging info.Like I said, I don't know anything about running a News magazine, and, to me, and ( I know I cannot be the only DBA with this concern ), but, you risk relevance.Tue, 05 Jul 2011 07:19:21 GMTWinston Daley-344648http://www.sqlservercentral.com/Forums/Topic1136933-433-1.aspxHi Everyone,I tries to take a database offline and move the files to another location. I got an error message: Set offilinefailed for Database 'XXXX'Additional information:An exception occurred while executing a Transaction - SQL statement or batchAlter Databased failed because a lock could not be placed on database 'XXXX', try again later.Alter database statement failed (microsoft SQL Server, Error 5061)What should I do?Thank youYanTue, 05 Jul 2011 17:07:22 GMTyan-160997http://www.sqlservercentral.com/Forums/Topic1133678-433-1.aspxWould be nice if the question of the day actually stated the correct answers.Wed, 29 Jun 2011 06:48:37 GMTsturnerhttp://www.sqlservercentral.com/Forums/Topic672569-433-1.aspxCan I come to know top 10 scores above my score.As current user can see his/her score in last 30 days on home page.Score system should be updated to find top 10 records above that score.Suppose in last 30 days score list, my rank is 11 and I want to see who else are above me in score list but here on Home page I am able to see only top 5 Members. Hope editor will think on this suggestion.Cheers,NavnathTue, 10 Mar 2009 09:53:18 GMTnavnath.n.kalehttp://www.sqlservercentral.com/Forums/Topic1123866-433-1.aspxToday I tried to check one of my posts 3 months ago, but I cannot find my post.The earlist is April's post. I changed my account once, because my work changed and have a new email address, does it mean if we changed email, all our past posts got lost?Any one has the experience?ThanksSat, 11 Jun 2011 22:15:54 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1122028-433-1.aspxCan you please add the article, forum, etc. Date for search returns screen? Should be orrderable too, btw.Wed, 08 Jun 2011 12:52:13 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic1113988-433-1.aspxHi ALL, I wa studying about indexes in Stairways series.lot of content is missing could you please help in getting the full content.ThanksTue, 24 May 2011 07:10:35 GMTvino5786http://www.sqlservercentral.com/Forums/Topic1110842-433-1.aspxMy Posts doesn't contain all my posts. For instance, I definitely posted here:http://www.sqlservercentral.com/Forums/Topic662333-1480-1.aspxBut when I search the My Posts link, it is not there. Not a show-stopper but irritating. ;-)HTHDave JEdited for grammer, spelling mistakes etc. that I never see on first read...Wed, 18 May 2011 05:18:05 GMTDavid Jacksonhttp://www.sqlservercentral.com/Forums/Topic1105873-433-1.aspxYou'll find quite a few posts in the SSRS part of the forum.User "kkupchyk 4137" has 6 posts all recommending a third party non-SSRS software. User "mikebally888" has 18 posts all doing the same thing, another third party software.Perhaps you can find others, do a cleanup, and set an sqlagent job to find and notify you of similar intrusions in future?Tue, 10 May 2011 00:27:51 GMTwww.ssrstips.comhttp://www.sqlservercentral.com/Forums/Topic1096922-433-1.aspxHow do I change my nickname in SSC? Even I changed in My Account, it is not showing with the updated one? How do it relate with the login id?Thu, 21 Apr 2011 06:07:33 GMTsqlzealot-81http://www.sqlservercentral.com/Forums/Topic1091462-433-1.aspxcan you guys tweak the html on the textarea for Editing your signature?it is annoyingly skinny, and appears that way in all browsers(IE,FireFox,Chrome)the core issue is the style for height is missing the pixels:[b]height:300;[/b] should be [b]height:300px;[/b][img]http://www.stormrage.com/SQLStuff/signature_nospace.png[/img]FYI, the html current definition of the textbox is:[code="plain"]<textarea name="txtSignature" id="txtSignature" tabindex="1" class="FormInputText" style="width:100%; height:300; border-left:0px; border-bottom:0px; border-top:1px #7F9DB9 solid; border-right:1px #7F9DB9 solid; padding:3px; background-color:White;">stuff></textarea>[/code]Mon, 11 Apr 2011 08:25:46 GMTLowell