Reputation
Top tag
Next privilege 20 Rep.
Talk in chat
Badges
1
Newest
 Student
Impact
~577 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
25
awarded  Student
Sep
25
comment SQL Server 2008 R2 clustered index issue
I too agree with you both. On facing the issue, First thing which I checked is whether it is static cursor or dynamic cursor but that is not the point, because no update is done on clustered index columns. Moreover, as already mentioned, dropping of clustered index makes the cursor to run perfect, existence of clustered index makes it run infinite times. Here, there is no point in considering whether it is a dynamic cursor or static cursor. Regards, K.P.Senthil Kumar
Sep
25
asked SQL Server 2008 R2 clustered index issue