SQL SERVER – The Limitations of the Views – Eleven and more…

I earlier wrote interesting article series on the limitations of the views. I had great time writing this series. I got many many request to write more on the subject but honestly, I think I gave my best to the subject.

I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject. If you write an article and send it to me, I will publish it on this blog with due credit to you. If you write on your own blog, I will update this blog post pointing to your blog post.

Limited View

Limited View

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

14 thoughts on “SQL SERVER – The Limitations of the Views – Eleven and more…

  1. Pingback: SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion Journey to SQL Authority with Pinal Dave

  2. Pingback: SQL SERVER – Indexed View always Use Index on Index Journey to SQL Authority with Pinal Dave

  3. Pingback: SQL SERVER – List of all the Views from Database Journey to SQL Authority with Pinal Dave

  4. Hey pinal here one more limitation of the Indexed View

    I got the error while createing IV from synonyms.

    Error : -Msg 2788, Level 16, State 1, Procedure U_ALLOBJECT, Line 4
    Synonyms are invalid in a schemabound object or a constraint expression.

    Like

  5. Pingback: SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz Journey to SQL Authority with Pinal Dave

  6. Pingback: SQL SERVER – Index Created on View not Used Often – Limitation of the View 12 Journey to SQL Authority with Pinal Dave

  7. Pingback: SQL SERVER – Index Created on View not Used Often – Observation of the View Journey to SQL Authority with Pinal Dave

  8. Pingback: SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer Journey to SQL Authority with Pinal Dave

  9. Pingback: SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 « Journey to SQLAuthority

  10. Pingback: SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s