<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Articles with tag
Indexed Views
Search for
any
content tagged
indexed views
Items 1 to 13 of 13
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
|
21,368 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
|
3,689 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,734 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,662 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,012 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
|
21,368 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
|
51,492 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,612 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,404 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
|
5,990 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
|
Category:
sql server 2008
Rating:
Rate this
|
Briefcase
|
2,998 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
|
51,492 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
|
11,792 reads
Items 1 to 13 of 13
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
