Viewing 15 posts - 91 through 105 (of 216 total)
Roy Ernest (2/3/2009)
Out of curiosity, are you formatting the data returned in any way before you casted it to decimal?
No - prior to casting to a decimal to 'fix' the...
February 3, 2009 at 8:51 am
Max (2/3/2009)
February 3, 2009 at 8:09 am
Max (2/3/2009)
Another strange thought, can you re-index the table and check again?
Done ! And no change!
I actually reindexed yesterday, and updated all the stats, as my first thought was bad...
February 3, 2009 at 6:32 am
Jeff Moden (2/3/2009)
February 3, 2009 at 6:03 am
ALZDBA (2/3/2009)
What's the effect if you alter the sproc using theWith recompile parameter ?
Seems to me cardinallity may be very different when using criteria 1 or 2.
Makes no difference -...
February 3, 2009 at 5:26 am
ALZDBA (2/3/2009)
Can you compare (or even post) the execution plans for both queries ?
The execution plans are identical.
Attached is the screenshot of the 2 plans - I can post the...
February 3, 2009 at 3:45 am
Max (2/3/2009)
Strange thought I just had but could it be possible that the data is stored on a partition\segment that is not...
February 3, 2009 at 3:26 am
ALZDBA (2/3/2009)
I've experienced SSMS with results to grid generating our client antivirus to interfere (not with every select, but every time with...
February 3, 2009 at 2:20 am
Jeff Moden (2/2/2009)
February 3, 2009 at 2:18 am
I'm going to try it from home tonight to see if a different client (aside from the work network) has the same results and to see if the DB server...
February 2, 2009 at 10:36 am
Todd,
it is happening everytime with one id and not with another - but I've checked anti-virus and that isn't kicking in.
Kev
February 2, 2009 at 10:23 am
Why/how would DNS affect this?
(not saying I don't believe you I just want to know more!!)
ALZDBA - The server is hosted elsewhere, but it's not accessed via a VPN -...
February 2, 2009 at 10:17 am
Interesting.....
Robert - it did seem to work OK, and I wasn't getting the error in SSMS in my test environment. Strangely though, the error was still raised when the...
January 30, 2009 at 9:23 am
Thanks for the responses.
Robert - not sure how this guarantees to avoid the violation.
Ken - I hadn't thought about application locks - sounds good! I just need to do a...
January 30, 2009 at 5:57 am
wow - me too - not sure if I'm a regular enough forum poster to deserve a shirt but I have contributed articles and questions 🙂
Kev
January 28, 2009 at 8:04 am
Viewing 15 posts - 91 through 105 (of 216 total)