Please provide more information.

1. How do you want to update the table?

2. What is the logic in the loop?

3. Are you going to update one table or multiple tables?

We have implemented by storing the application logged in user in the last modified user column for all the table which will be audited via a trigger to the audit...

If you have a transaction log backup then you can restore to the point of time when the DELETE statement was executed or upto log sequence number (LSN) to recover...

I think SSC should filter out these type of questions from publishing...

This is totally an incorrect answer. According to the http://msdn.microsoft.com/en-us/library/ms175049.aspx it shows the below 10 indexes:

1. Clustered

2. Nonclustered

3. Unique

4. Columnstore

5. Index with included columns

6. Index on computed columns

7. Filtered

8. Spatial...

Hi,

I don't know how it will affect your performance but definetely cursor is going to slow down the performance of your script above. In your case, how many records the...

Hi,

What is the size of the tables you are deleting? If they are big delete the data in chunks.

Regards,

Ravi.

Hi,

SQL stores the current identity value generated in last_value column of sys.identity_columns table with this value SQL knows which value to be generated next based the increment_value column.

--Ravi.

Hi Farooq,

You cannot use SELECT ... INTO with a table variable, you should only use INSERT INTO ... SELECT.

--Ravi.

Hi Mohan,

What is the size of the log file? If the log file is big try to take the backup of the log files (provided your recovery model is FULL...

Hi gpm.alwyn,

Along with table structure, please provide the query which you are using currently.

--Ravi.

Hi Prasad,

Please try this SELECT statement below:

select t.ID,t.name,t.value,(select sum(s.value) from T1 s where s.id<=t.id)

from T1 t

Performance wise, solution given by Cadavre is good and Dwain's query is also good if the CASE statement is avoided. The CASE statement is adding some weight to the query's...

Hope this should work. Please try this...

update VectorReplica.dbo.PARCELS set PARCEL_ID = b.new_pid from Ranieranneaxparcels AS A

inner join VectorReplica.dbo.PARCELS as B on

(B.[PARCEL_ID] = b.[NEW_PID])

-Ravi.

And updated with latest service pack (SP2)