Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Views Rss

Search for any content tagged views

   Items 1 to 15 of 15   
 

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 13,747 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios.  Read more...
By Gregory Larsen 2014/03/19 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,034 reads

Using Views to Expose Encrypted Data in SQL Server

I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.  Read more...
By Additional Articles 2013/10/29 | Source: MSSQLTips.com | Category: views
Rating:  Rate this |   Briefcase | 4,069 reads

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.  Read more...
By Additional Articles 2013/07/16 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 3,003 reads

What a View

I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.  Read more...
By John Esraelo 2012/10/02 | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 7,659 reads

Views and Dependencies

Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views  Read more...
By John Reitter 2012/07/10 | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 5,229 reads

SQL View: Beyond the Basics

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.  Read more...
By Additional Articles 2012/06/21 | Source: SimpleTalk | Category: views
Rating:  Rate this |   Briefcase | 4,525 reads

SQL VIEW Basics

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.  Read more...
By Additional Articles 2012/06/01 | Source: SimpleTalk | Category: views
Rating:  Rate this |   Briefcase | 5,256 reads

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 13,747 reads

Using Views and Synonyms for Abstraction - SQL School Video

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.  Read more...
By Brian Knight 2009/01/22 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,289 reads

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

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?  Read more...
By Additional Articles 2008/12/12 | Source: MSSQLTips.com | Category: metadata
Rating:  Rate this |   Briefcase | 3,408 reads

Easily Access Remote Data Using SQL Server Views

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.  Read more...
By Additional Articles 2008/11/19 | Source: DevX | Category: views
Rating:  Rate this |   Briefcase | 2,761 reads

Creating Views - SQL School Video

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.  Read more...
By Brian Knight 2008/07/31 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,247 reads

View Column Resolving Issue in Sub-Query

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.  Read more...
By Peter He 2008/01/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,541 reads

Views for Abstraction

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.  Read more...
By Andy Warren 2007/10/25 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 4,882 reads
   Items 1 to 15 of 15