Reputation
Next privilege 200 Rep.
See reduced ads
Badges
8
Newest
 Tumbleweed
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Oct
26
accepted Is there an actual problem in my storage IO or is the data incorrect?
Oct
26
asked Is there an actual problem in my storage IO or is the data incorrect?
Apr
6
accepted SQL Server index causing incorrect behavior on cursors
Apr
6
comment SQL Server index causing incorrect behavior on cursors
Wow.. thats bizzare that solved our issue. Time to look into what this KEYSET magic is. If you want to edit your answer, i'll accept it.
Apr
6
comment SQL Server index causing incorrect behavior on cursors
With index IX_SRCHGT produces same issue, but with index PK_SRCHGT eliminates it. However, this is still problematic because we can't possibly append every queries with a particular index we're trying to update with. Also, selecting the data with PK is very slow in our case.
Apr
6
comment SQL Server index causing incorrect behavior on cursors
@MaxVernon I am able to reproduce this issue with the sample. I've edited the question with the DDL
Apr
6
revised SQL Server index causing incorrect behavior on cursors
added 2787 characters in body
Apr
6
asked SQL Server index causing incorrect behavior on cursors
Apr
6
accepted SQL Server stored procedure causing 100% CPU usage
Apr
6
accepted SQL Server collecting SQL statements using particular index
Apr
1
asked SQL Server collecting SQL statements using particular index
Mar
3
awarded  Tumbleweed
Feb
24
asked SQL Server 2008 R2 - Capture or be notified when an sql handle is ran
Feb
17
awarded  Curious
Feb
16
asked SQL Server 2008 R2 - Should I be worried at this statistics regarding indices causing locks?
Feb
6
asked SQL Server stored procedure causing 100% CPU usage
Apr
17
revised Can comments in stored procedures cause problems
added 60 characters in body
Apr
17
comment Can comments in stored procedures cause problems
Oh woops. That was a mistake on my part. The code is supposed to be the same but I miscopied them.
Apr
16
revised Can comments in stored procedures cause problems
added 53 characters in body
Apr
16
asked Can comments in stored procedures cause problems