Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Indexed Views Rss

   Items 1 to 20 of 20   
 

SQL Server Indexed Views: The Basics

Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.  Read more...
By Additional Articles 2014/02/26 | Source: SimpleTalk | Category: indexed views
Rating: (not yet rated)  Rate this |   Briefcase | 3,504 reads

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.  Read more...
By Sarvesh Singh 2013/05/10 (first published: 2010/11/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,950 reads

If you are using indexed views and MERGE, please read this!

Here is some information about an important MERGE “wrong results” bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem.  Read more...
By Aaron Bertrand 2013/02/14 | Source: SQLPerformance.com | Category: indexed views
Rating:  Rate this |   Briefcase | 4,006 reads

Move all SQL Server indexed views to a new filegroup

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 2,843 reads

Enforce business rules with indexed views and a two-row table

Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.  Read more...
By Dan Ryan 2012/08/20 | Source: SQLServerCentral.com | Category: business rules
Rating: |  Discuss |   Briefcase | 7,735 reads

Indexed Views In Non-Enterprise Editions of SQL Server

CAN you create AND USE an indexed view in non-Enterprise Editions of SQL Server?  Read more...
By Steve Knox 2012/04/10 | Source: SQLServerCentral.com | Category: editions
Rating: |  Discuss |   Briefcase | 7,235 reads

Indexed Views

By Steve Knox 2012/02/10 | Category: features
Rating: (not yet rated) |  Discuss |   Briefcase | 2,359 reads

Enforcing surrogate key uniqueness in slowly changing dimension

Enforcing surrogate key uniqueness regards natural key in slowly changing dimension  Read more...
By Federico Iori 2012/01/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 655 reads

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.  Read more...
By Sarvesh Singh 2013/05/10 (first published: 2010/11/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,950 reads

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...
By Muhammad Shujaat Siddiqi 2010/10/01 (first published: 2009/04/29) | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 54,286 reads

Ways to minimize sort operations

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.  Read more...
By Brian Ellul 2010/09/15 | Source: SQLServerCentral.com | Category: sort operator
Rating: |  Discuss |   Briefcase | 10,707 reads

SQL Server Indexed Views

Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.   Read more...
By Additional Articles 2010/04/05 | Source: Database Journal | Category: indexed views
Rating:  Rate this |   Briefcase | 4,507 reads

Roll Your Own Materialized Views

Simple but elegant alternative to indexed views.  Read more...
By Mark Stockwell 2010/02/11 | Source: SQLServerCentral.com | Category: materialized view
Rating: |  Discuss |   Briefcase | 1,258 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,091 reads

Indexed view

By VM-723206 2009/07/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,099 reads

Creating Indexed Views - SQL School Video

An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.  Read more...
By Andy Warren 2009/06/30 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 6,621 reads

Improving Performance with SQL Server 2008 Indexed Views

This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.  Read more...
By Additional Articles 2009/06/19 | Source: TechNet Blogs | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,057 reads

Indexed views

By VM-723206 2009/06/09 | Category: indexed views
Rating: (not yet rated) |  Discuss |   Briefcase | 3,915 reads

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...
By Muhammad Shujaat Siddiqi 2010/10/01 (first published: 2009/04/29) | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 54,286 reads

On Indexes and Views

A short description of requirements to fully utilize the indexes on views.  Read more...
By Timothy A Wiseman 2008/09/09 | Source: SQLServerCentral.com | Category: indexed views
Rating: |  Discuss |   Briefcase | 12,070 reads
   Items 1 to 20 of 20   
 
Tags
performance tuning (3)    
editions (2)    
features (2)    
merge (2)    
t-sql (2)    
administration (1)    
basics (1)    
business rules (1)    
clustered index (1)    
covering indexes (1)    
dbcc dropcleanbuffers (1)    
dbcc freeproccache (1)    
dbms_mview (1)    
dbms_snapsnot (1)    
dimension (1)    
dwh (1)    
execution plans (1)    
filegroups (1)    
indexing (1)    
maintenance and management (1)    
materialized view (1)    
multithreaded partition access (1)    
natural key (1)    
non clustered indexes (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
primary key (pk) (1)    
scd (1)    
search (1)    
sliding windows (1)    
sort operator (1)    
split (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sqlclr (1)    
storage management (1)    
stored procedures (1)    
surrogate key (1)    
switch (1)    
table partition (1)    
tables (1)    
utility (1)    
video (1)