Insert with TABLOCK hint - Faster

[PavanKumar Bolikonda]

Hi, Will this option be effective for Azure SQL Database(Full Recovery) as well. Please confirm.

[Philippe Almog]

Thanks a lot, really useful indeed

[Margaret Norkett]

Can this be used with deletes as well as inserts? For example, on a table that has millions of rows and you are trying to delete ~ half of them -- you've taken a backup, so can revert if there is a problem.