SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Views Rss

   Items 1 to 20 of 58    Older >>
 

Rebuild or recompile all views

Simple script to refresh or recompile your business-level views.  Read more...
By Doug Deneau 2017/10/05 | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 477 reads

The autogenerated view

By Grant Fritchey 2016/12/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 989 reads

Dropping a view

By Steve Jones 2016/11/11 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,325 reads

Refresh all views in a database

Refresh all views in a database  Read more...
By S M 2016/10/28 | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 776 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,183 reads

Updating a View with CHECK

By Steve Jones 2016/09/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,216 reads

Where's the error?

By Steve Jones 2016/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,531 reads

Updating the View or the table?

By Steve Jones 2016/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,407 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 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,855 reads

The View Insert

By Steve Jones 2016/07/14 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,416 reads

Summed Views

By Steve Jones 2016/06/27 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,348 reads

The altered view

By Steve Jones 2016/06/09 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,436 reads

Looking at VIEWs, Close Up

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.  Read more...
By Additional Articles 2016/06/07 | Source: SimpleTalk | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 6,901 reads

Size of view

By Karthik Babu 2015/07/27 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 reads

Views

By Shiva N 2015/07/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,943 reads

Finding SQL Server views with (or without) a certain property

In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.  Read more...
By Additional Articles 2014/12/12 | Source: MSSQLTips.com | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 5,826 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,821 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 | 974 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 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,855 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,672 reads
   Items 1 to 20 of 58    Older >>
 
Tags
t-sql (28)    
encryption (3)    
triggers (3)    
administration (2)    
stored procedures (2)    
video (2)    
advanced t-sql (1)    
azure (1)    
blogs (1)    
c# (1)    
cte (1)    
data lake (1)    
database design (1)    
dependency (1)    
dmv (1)    
dynamic (1)    
expressions (1)    
formatting (1)    
function (1)    
functions (1)    
indexing (1)    
metadata (1)    
miscellaneous (1)    
partitioning (1)    
rebuild (1)    
recompile (1)    
refresh (1)    
select (1)    
sp_refreshview (1)    
sp_rename (1)    
stairway series (1)    
stored procedure (1)    
synonyms (1)    
sys (1)    
syscomments (1)    
update (1)    
usage (1)    
u-sql (1)    
with check option (1)