Thanks Grant Fritchey.

Can you please complete my example & give solution for 3NF.

By keeping NOT NULL, sql server has to check for NOT NULL before insertion of each row. so that's my question whether it would increase performance & would be it...

Cris,

Do you mean query 2 will run fast than query 1

Query1

UPDATE tb_Transaction

SET n_TransactionID = 0

FROM tb_Transaction A

INNER JOIN tb_Manager B

ON A.n_ManagerNo = B.n_ManagerNo

LEFT OUTER JOIN tb_TransactionHistory C

ON A.n_TransactionNo = C.n_TransactionNo

WHERE...

Its all right but i want to know the techniques to handle concurrency i.e. Lost updates

Hi,

The expected level of concurrency

- How many total users = 25

- How many users actually hitting the database at the same time = 10

- How many users actually hitting the...