Pages

Saturday, September 7, 2013

SQL SERVER – Outer Join in Indexed View – Question to Readers | Journey to SQL Authority with Pinal Dave

Today I have question for you. Just a day ago I was reading whitepaper Improving Performance with SQL Server 2008 Indexed Views. Following is question and answer I read in the white paper. Q. Why can't I use OUTER JOIN in an indexed view? A. Rows can logically disappear from an indexed view based on… Continue Reading...

Source: SQL SERVER – Outer Join in Indexed View – Question to Readers | Journey to SQL Authority with Pinal Dave