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 | 298 reads

The autogenerated view

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

Dropping a view

By Steve Jones 2016/11/11 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,313 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 | 674 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,139 reads

Updating a View with CHECK

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

Where's the error?

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

Updating the View or the table?

By Steve Jones 2016/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,394 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,786 reads

The View Insert

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

Summed Views

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

The altered view

By Steve Jones 2016/06/09 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 1,427 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,830 reads

Size of view

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

Views

By Shiva N 2015/07/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,941 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,734 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 | 969 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,786 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,513 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)