Updating sql server

posted by | Leave a comment

The fastest way to speed up the update query is to replace it with a bulk-insert operation.

Acquiring a subtype lock without holding a nonsubtyped lock of the parent type is technically valid. Possible values are GRANTED, CONVERT, WAIT, LOW_PRIORITY_CONVERT, LOW_PRIORITY_WAIT, or ABORT_BLOCKERS.This can be done easily by doing a bulk-insert in a new table and then rename the table to original one.The required indexes and constraint can be created on a new table as required.In this tip I show that doing a statistics update does not cause blocking.This is a hot topic in the SQL Server DBA community.

Leave a Reply

Hot chat lines always free