Indexed Views

SQL Server Indexed Views: The Basics

  • Article

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.

2014-02-26

4,674 reads

Blogs

The 99 Flavours of SQL Server are all Vanilla

By

There are so many options for running SQL Server now. It can feel a...

Why do DBAs dislike loops?

By

If you started out as a developer you were probably taught how important loops...

Public and Demo Data Coming Soon!

By

Any database professional that has been around the Microsoft world for more than about...

Read the latest Blogs

Forums

Waits and Queues

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Waits and Queues

Synonyms for Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synonyms for Tables

install problem Missing >> Select a configuration task panel

By Digs

I have both MS SQL 2008 R2 and MS SQL 2014 (both developer editions)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers