|
I got a notice that my tip Documenting SQL Stored Procs in C# Code[^] was edited by Deeksha Shenoy to be "made publicly available". It was already public (it was already being voted on), so why was that necessary?
I don't really care for people going in and messing with my articles unless I ask them to, or unless there's some sort of obvious markup problem.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
It looks like she just did a quick grammar sweep (only one word was changed) and fixed a few .Net's to .NET. From an editor perspective, sometimes doing a quick edit gives you a sense of accomplishment that helps fuel you to edit a bigger one.
But we don't want to annoy, I can tell all editors not to touch unless you ask us to.
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
Sorry for my comment on this... but in case it was really Quote: (only one word was changed)
Where is the rotten egg in your article, whom you are afraid? I do not find it, so be relaxed.
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Lately, my answer was marked as "Pending". Ok, I was waiting... and waiting. Nothing happened. Than I refreshed the page. My answer was gone. I rewrote it: "Pending" again. Than suddenly I got a comment to my first answer. I refreshed the page and there it was, already accepted by OP - and the second shot still in pending state. How come these all together? Quite strange...
|
|
|
|
|
Your answer was trapped by the spam filter. Something you wrote made the filter think you were trying to post something you shouldn't be posting.
cheers
Chris Maunder
|
|
|
|
|
Well, it appeared after all, without any change. But check for yourself Voice recorder suggestion for my website[^] and tell me what should I avoid writing...
And what about the fact that OP was able to see my answer whilst I wasn't?
If this isn't a bug...
|
|
|
|
|
When a message is trapped by the Spam filter it gets posted to a queue on the home page, until one of us with the appropriate privilege releases it. A bit of a pain I know, but the site is getting attacked lately by spammers. Take a look in the Spam and Abuse forum to see how many get picked up every day.
|
|
|
|
|
Did someone forget to push the "turbo" button on one of your servers? Every page is taking 12+ seconds to get a response from the server, and judging by this thread[^], it's been going on for over six hours.
EDIT: And, as if by magic, as soon as I post this message, the response times are back to normal. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
We've just spent the better part of an hour trying to work out what happened.
It turns out for a single sproc, there were two cached plans. One sensible, one not. The sensible plan was what was being shown in SQL Server Management studio (which has ARITHABORT = ON). Running under .NET, ARITHABORT is FALSE, and so our code was getting the other, crappy plan.
DBCC FREEPROCCACHE didn't work.
Messing with the connection object in .NET worked - but was clumsy.
Out came the hammer and I've manually changed the database default - bingo, instant fix. Except it's a band-aid so I need to ensure that the execution plan with and without ARITHABORT are both sensible.
(How on EARTH are you meant to know these things off-hand? DBA stuff can send a man insane)
cheers
Chris Maunder
|
|
|
|
|
Been there, got the t-shirt. 
You can use SET ARITHABORT ON inside an individual stored procedure, if you don't want to change the database or server default.
There's some good discussion of the problem on this StackExchange thread[^], and some fairly detailed information in this article[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: You can use SET ARITHABORT ON inside an individual stored procedure
Only if you have a GO statement after the SET OPTION statement. That wasn't working for us.
cheers
Chris Maunder
|
|
|
|
|
Not according to "option 2" in this answer[^]:
CREATE PROCEDURE ...
AS
BEGIN
SET ARITHABORT ON
SELECT ...
END
GO
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yeah - I saw that was possible syntactically, but I was reading that it doesn't actually make the change.
I should have experimented but the klaxons were blaring and there were lots of wild eyes.
The thing that did my head in (mostly) was that the sproc plan cache did not seem to be getting flushed after the DBCC call. And then suddenly it was.
Insanity.
cheers
Chris Maunder
|
|
|
|
|
Chris Maunder wrote: (How on EARTH are you meant to know these things off-hand? DBA stuff can send a man insane)
Don't forget to vote on this week's CP poll "Does programming frustrate you?" 
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
frustrate != (drive crazy || send insane) 
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Chris Maunder wrote: DBA stuff can send a man insane
So true. 
|
|
|
|
|
Only for Information: Also here (Switzerland) the whole day CP responded very slow. I checked internet connection, a different browser... nothing was wrong. Since about 18:00 normal Response time.
modified 19-Jan-21 21:04pm.
|
|
|
|
|
The issue started 5:20PM Toronto time. Unfortunately the site performance didn't degrade enough to trigger our alerts. It was bad - but not bad enough!
cheers
Chris Maunder
|
|
|
|
|
Be happy that it is ok now, I am happy so far 
modified 19-Jan-21 21:04pm.
|
|
|
|
|
I've asked a question at QA[^], and got an answer...but got 20! notifications about it...(I left 18 there to see)...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
I'm guessing the original poster had his post marked as spam and then kept trying to repost.
cheers
Chris Maunder
|
|
|
|
|
Message Removed
modified 14-Oct-15 9:54am.
|
|
|
|
|
Message Removed
modified 14-Oct-15 10:04am.
|
|
|
|
|
Hello,
I have a blog which uses Jekyll and Octopress to generate a static site. For code highlighting I use OctoPress's triple-tick
syntax. Apparently it generates an ugly HTML which makes it unreadable when imported to CP.
When a blog article is consumed, would it be affected by any changes I make to the original source?
My plan is to publish the post with pre tags around the code snippets then once it's consumed and looks nice on CP I can update my original post with the triple-ticks.
Of course I'd appreciate if you recommend an easier/better way.
Thanks.
|
|
|
|
|
Can you please send me a link to your blog's RSS or a sample of the HTML it generates? Email chris at codeproject.com and I'll see if I can make things easier.
cheers
Chris Maunder
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
