backup log database_name with truncate_only

backup log with truncate_only

Why are you processing this row-by-row within VB?

Much better to perform the validation in SQL, using set-oriented queries. The performance should be massively better.

When validation is complete, one insert statement...

Use ROWLOCK hint on the DELETE and NOLOCK hint on the SELECT.

Setting transaction isolation level to read uncommitted is different to using NOLOCK, since it may allow your users to...

Jon

The number of bytes occupied in the varchar field will be equal to the number of characters stored. So, if you insert a value which is 20 characters long, then...