Hi krypto,

instead of using Dynamic SQL and othe advices Follow Please use coalesce Like Below .. Do u still have problem let me know

SELECT

...

U can reduce the block time and transaction Log by using single insert statement in Batch instead of multiple insert statements. u can modify the batch such that it reduce...

I believe the SQL Express would allow maximum storage upto 4GB.. For batch execution for ur case (multiple table and size>10MB ) needs loads of Transactions.. This will grow the...

Hi guys

Try with snapshot isolation levels. it will reduce the db blocking Massively ., bu it will require large tempDB...