• If your OLAP is well designed then my recommendation is for it. It doesn't touch the OLTP database(s) i.e. doesn't put extra locking on the tables. OLAP can be also used by reporting services.

    However, the mind-set thinking is different from the one needed for T-SQL development.

    Igor Micev,My blog: www.igormicev.com