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

Scripts with tag Views Rss

Search for any content tagged views

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   
 

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

Display Rows Vertically or Alphabetically

Display a row vertically when a table has hundreds of columns to avoid scrolling.  Read more...
By William Talada 2010/01/21 | Source: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 2,745 reads

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.  Read more...
By David Hay 2009/08/17 | Source: SQLServerCentral.com | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 764 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,652 reads

Aggregating Index usage information

This script aggregates index usage stats into a view.  Read more...
By sql frenzy 2008/11/25 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,231 reads
   Items 1 to 5 of 5