After we indexed the views we got the following error:

DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'.

If you go to the following link http://support.microsoft.com/default.aspx?scid=kb;en-us;305333

They suggest...

Hi Paul,

We tried to create materialized view in order to check performance but we face another problem.

Suppose we have table X and we do 2 joins on it. The first...