SQLServerCentral.com Articles tagged Views

What a View

Tue, 02 Oct 2012 06:00:00 UT

I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.

Views and Dependencies

Tue, 10 Jul 2012 06:00:00 UT

Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views

SQL View: Beyond the Basics

Thu, 21 Jun 2012 06:00:00 UT

Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.

SQL VIEW Basics

Fri, 01 Jun 2012 06:00:00 UT

SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Unexpected View Performance

Tue, 11 Jan 2011 07:00:00 UT

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.

Using Views and Synonyms for Abstraction - SQL School Video

Thu, 22 Jan 2009 07:00:00 UT

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.

Using SQL Server meta data to list tables that make up views

Fri, 12 Dec 2008 07:00:00 UT

One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?

Easily Access Remote Data Using SQL Server Views

Wed, 19 Nov 2008 07:00:00 UT

Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.

Creating Views - SQL School Video

Thu, 31 Jul 2008 06:00:00 UT

This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.

View Column Resolving Issue in Sub-Query

Wed, 02 Jan 2008 07:00:00 UT

Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.

Views for Abstraction

Thu, 25 Oct 2007 06:00:00 UT

Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.