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

Articles with tag Indexed Views Rss

Search for any content tagged indexed views

   Items 1 to 14 of 14   
 

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,579 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,993 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,032 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,864 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,743 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,275 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,993 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,593 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,719 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,533 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,763 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,073 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,593 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,118 reads
   Items 1 to 14 of 14