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

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Read the latest Blogs

Forums

sql help

By Tara-1044200

I am trying to get the multiple tables from multiple dbs together in a...

Apply Classifications to SSRS Report headers/footers

By sol

We have many reports and are looking for a way to apply header/footer classifications...

Partition by used to count records (to find dupes)

By DaveBriCam

I'm getting an error in the following query, can anyone help with? Of course...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers