Currently browsing tag

View

INFORMATIONSCHEMA

INFORMATION_SCHEMA Introductions When we are taking about any RDBMS, it should be a data dictionary or metadata. MS SQL Server has no exceptions. In MS SQL Server there are two sources to view the metadata information.   1.    Various System Tables 2.    INFORMATION_SCHEMA views In this article I am trying …

Index of Materialized View Not Working

Index of Materialized View Not Working Introduction I got a mail from one of my closed friends related to “Materialized view Index not working”. I am little bit confused after getting this mail. When I am getting closer look at the problem that I understand what he mean by “Materialized …

Why VIEW takes long time to Execute

Why VIEW takes long time to Execute Here in this article we are discussing related to the performance of the views. Why the performance of the view is slow. Please note that I am not taking about the indexed views, it’s another thing and out of the scope of this …

Materialize view and the performance issue

Materialize view and the performance issue   In this article I am trying to illustrate some points related to materialize view and the performance issue. Views are the good example to handle the complex query. Thinks about the situations like this If a view performs an aggregation of millions of …

About VIEW

About VIEW   One of my friend ask me about view, I know that everyone has the solid idea related to view in MS SQL server. This article is dedicated to the learners who want to know about view. In my article I am trying to make it simple as …

Indexed View

Indexed View Views allow you to create a virtual table by defining a query against one or more tables. With a standard view, the result is not stored in the database. Instead, the result set is determined at the time a query utilizing that view is executed. Creating a unique …