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

Daily Coping 26 Nov 2020

By

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

Azure SQL Database – Greatest and Least TSQL

By

Being in the cloud does have many benefits, from lower administration to fast scaling...

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Read the latest Blogs

Forums

Large Database Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Large Database Files

Black Friday Wishes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Black Friday Wishes

Reporting Services Subscription: Special character in email address

By shell_l_d

Hi How can an email address containing a special character (in this case, an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers