Thank you for the response. You are correct that it is doing read to get the last id, increment by 1 and then insert into table with new id. Would...

Hi Michael, Do I do this when I have a deadlock and turn it off again after I find the issue? Is there any performance penalty because of this?

I checked our sql server edition. It is standard edition. So, I don't have option of rebuilding indexes with ONLINE option. If I disable the indexes and enable the indexes...

Hi, Thank you for the response. Please see my answers

1. What column(s) is the clustered index on and what are their datatypes?

we have a column named "Uniqueid". It is datatype...

Thank you for the reply. I only specified select * here because I didn't want to type all column names. we usually specify column names.

Thank you Florian.

Hi Florian,

Thank you for the detailed response. We are using the Classic Visual Basic 6.0. we are thinking that the insert statement is timing out because the table has a...

The insert statement is the only one inside the stored procedure. I thought that when Visual Basic calls the stored procedure, it will wait for 30 seconds (time out value)...

I figured it out. The table HistoryTable has posttypes "E", "D", "T" etc. Most of the times we query for posttype "E". So, I created a filtered index where posttype...

It is char(1) column. So, there shouldn't be any spaces.

Thank you. It makes sense. But I don't understand why it will have so many logical reads. It is in fact way more than the number of pages used to...

Thank you bitbucket. I do run most of the queries using SSMS. I usually do "Include Actual Execution Plan". That is how I found about this. I will run some...

Thank you. sometimes we use queries like "select * from dbo.Employees where company = @company and empno = @empno" when we know the company and empno.

when we join to another...

The vb application just calls the stored procedure. The stored procedure does the copy of records. As of now it is the only stored procedure that inserts data into the...

Hi,

Thanks for the reply. I am not sending the records back to client. It doesn't time out every time. Also the target table has lot of indexes.

Thanks,

sridhar.