Ars Technica

bcp and arithabort problems with indexed views (SQL Server 2000)

I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on ...
Network World

Indexed Views are a good feature but in which Edition?

Now Books Online 2005 has been updated to specify exactly what happens using a subtext item: “This feature is supported in all editions of SQL Server 2005, except that indexed view-to-query matching ...
ASCII.jp

SQL Serverで元のクエリを参考にしてIndexを作成、最適化する方法

本記事はFIXERが提供する「cloud.config Tech Blog」に掲載された「【実践編】SQL Server にて Index を作成する」を再編集したものです。 SQL Server にてIndexを作成しようとしたところ、元のクエリを参考にしてIndexを作成するような記事がすぐに見つからなかったので ...
Ars Technica

TSQL/MSSQL Theory - Indexed Views - benefits and what they are exactly?

Ok, so I'm reading about Indexed Views and I see that another feature of Enterprise edition is that it can substitute them into a standard query when the query optimizer runs the query if it so ...