Lynn Pettis (6/17/2015)

---

Andrei Hetel (6/16/2015)

---

It could be another approach. If you are deleting 50% of the records as mentioned in the earlier post, it could be quicker to do something...

Something like this, assume memberid is varchar column.

DECLARE @IDList VARCHAR(MAX)

SELECT

@IDList = COALESCE(@IDList + ',', '') + memberID

FROM your_table_name

PRINT @IDList

It could be another approach. If you are deleting 50% of the records as mentioned in the earlier post, it could be quicker to do something like this:

- stop the...

Why don't you call the 2nd stored procedure before committing the transaction?

Are you using in the 2nd stored procedure some identity column values obtained in the first stored procedure?...

With nolock won't help you. Don't think you want to do a dirty read of your data. If you put some code in here we might figure out what the...

You need to post the code, otherwise nobody can help you. We might find a way to avoid using a cursor.

I wouldn't use a flag in the active table, queries based on active = 0/1 condition will most likely slow down your application.

My idea would be to create a history...

Start SQL Server Agent and create a SQL Server job.

The number of joins in that query is indeed impressive. I think the execution plan was changed. Did you add or drop any indexes recently?

An update trigger will do it nicely.

Being a correction query that you run only once, I wouldn't worry too much about it - as long as is doing its job.

Your concert should be to put...

'Deleted' and 'Inserted' table are created and maintained automatically by SQL Server. Both are temporary, memory-resident tables to test the effects of your data modifications

Inserted - contain new data (after...

Example:

Index create on table Customer, field JoinDate, and include 3 fields: Name, surname, phone

Following statement:

select Name, surname, phone

from Customer where Joindate between @startdate and @enddate

will use ONLY your INCLUDE index...

Not sure if looping through the whole table is the best solution. Can you provide more details about your problem?