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

Content with tag Views Rss

   Items 1 to 20 of 41    Older >>
 

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,688 reads

Partitioned Table View

This is my View for collecting information about partitioned tables.  Read more...
By Eric Eyster 2014/03/26 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 804 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 | 7,650 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,035 reads

SQL views

By Naseer Ahmad 2013/08/01 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,244 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 | 2,960 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,636 reads

Nested triggers 2

By Tom Thomson 2013/05/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,898 reads

Nested triggers 1

By Tom Thomson 2013/04/23 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 1,688 reads

Updating Views

By Steve Jones 2013/02/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,251 reads

My view isn’t reflecting changes I’ve made to the underlying tables.

Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. Over...  Read more...
By Kenneth Fisher 2013/01/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,796 reads

Divide by zero

By Hugo Kornelis 2012/12/24 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,215 reads

VIEW - 9

By bitbucket-25253 2012/10/15 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,211 reads

View - 8

By bitbucket-25253 2012/10/08 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,396 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,654 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,226 reads

Views and changes

By Steve Jones 2012/07/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,790 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,499 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,234 reads

View 7

By bitbucket-25253 2012/05/08 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 2,459 reads
   Items 1 to 20 of 41    Older >>
 
Tags
t-sql (20)    
encryption (3)    
triggers (3)    
stored procedures (2)    
video (2)    
advanced t-sql (1)    
blogs (1)    
cte (1)    
database design (1)    
dba code (1)    
dmv (1)    
dynamic (1)    
formatting (1)    
function (1)    
functions (1)    
indexing (1)    
metadata (1)    
miscellaneous (1)    
partitioning (1)    
procedures (1)    
select (1)    
sp_rename (1)    
stairway series (1)    
synonyms (1)    
sys (1)    
syscomments (1)    
usage (1)