Click here to Skip to main content
15,887,474 members

Bugs and Suggestions

   

General discussions, site bug reports and suggestions about the site.

For general questions check out the CodeProject FAQs. To report spam and abuse Head to the Spam and abuse watch. If you wish to report a bug privately, especially those related to security, please email webmaster@codeproject.com

 
GeneralRe: Why was my article edited? Pin
Sean Ewington15-Oct-15 3:30
staffSean Ewington15-Oct-15 3:30 
GeneralRe: Why was my article edited? Pin
User 1106097915-Oct-15 4:11
User 1106097915-Oct-15 4:11 
Bug"Pending" Pin
Zoltán Zörgő14-Oct-15 7:41
Zoltán Zörgő14-Oct-15 7:41 
GeneralRe: "Pending" Pin
Chris Maunder14-Oct-15 8:45
cofounderChris Maunder14-Oct-15 8:45 
GeneralRe: "Pending" Pin
Zoltán Zörgő14-Oct-15 9:36
Zoltán Zörgő14-Oct-15 9:36 
GeneralRe: "Pending" Pin
Richard MacCutchan14-Oct-15 22:43
mveRichard MacCutchan14-Oct-15 22:43 
Question"Turbo" button Pin
Richard Deeming14-Oct-15 4:56
mveRichard Deeming14-Oct-15 4:56 
AnswerRe: "Turbo" button Pin
Chris Maunder14-Oct-15 5:05
cofounderChris Maunder14-Oct-15 5:05 
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

GeneralRe: "Turbo" button Pin
Richard Deeming14-Oct-15 5:20
mveRichard Deeming14-Oct-15 5:20 
GeneralRe: "Turbo" button Pin
Chris Maunder14-Oct-15 5:22
cofounderChris Maunder14-Oct-15 5:22 
GeneralRe: "Turbo" button Pin
Richard Deeming14-Oct-15 5:26
mveRichard Deeming14-Oct-15 5:26 
GeneralRe: "Turbo" button Pin
Chris Maunder14-Oct-15 10:58
cofounderChris Maunder14-Oct-15 10:58 
GeneralRe: "Turbo" button Pin
SoMad14-Oct-15 9:46
professionalSoMad14-Oct-15 9:46 
GeneralRe: "Turbo" button Pin
Nelek14-Oct-15 12:08
protectorNelek14-Oct-15 12:08 
GeneralRe: "Turbo" button Pin
Slacker00722-Oct-15 5:24
professionalSlacker00722-Oct-15 5:24 
GeneralRe: "Turbo" button Pin
User 1106097914-Oct-15 8:12
User 1106097914-Oct-15 8:12 
GeneralRe: "Turbo" button Pin
Chris Maunder14-Oct-15 8:44
cofounderChris Maunder14-Oct-15 8:44 
GeneralRe: "Turbo" button Pin
User 1106097914-Oct-15 9:45
User 1106097914-Oct-15 9:45 
BugToo many notifications... Pin
Kornfeld Eliyahu Peter14-Oct-15 1:53
professionalKornfeld Eliyahu Peter14-Oct-15 1:53 
GeneralRe: Too many notifications... Pin
Chris Maunder14-Oct-15 9:17
cofounderChris Maunder14-Oct-15 9:17 
QuestionMessage Removed Pin
14-Oct-15 1:41
Member 1200191614-Oct-15 1:41 
SuggestionMessage Removed Pin
14-Oct-15 1:37
Member 1200191614-Oct-15 1:37 
SuggestionImporting technical blog - code highlighting Pin
User 955792414-Oct-15 1:02
User 955792414-Oct-15 1:02 
GeneralRe: Importing technical blog - code highlighting Pin
Chris Maunder14-Oct-15 4:05
cofounderChris Maunder14-Oct-15 4:05 
GeneralRe: Importing technical blog - code highlighting Pin
User 955792415-Oct-15 4:19
User 955792415-Oct-15 4:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Flags: AnsweredFixed

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.