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

Content with tags T-SQL, Schema Rss

   Items 1 to 5 of 5   

Which Statement will execute sucessfully

By malls reddy 2012/12/07 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 2,084 reads

Copy One Schema to Another Schema

This script copies one object in another multiple schema.  Read more...
By Vinay Kumar 2011/08/31 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,173 reads

default schema trouble

By Nils Gustav Stråbø 2010/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,151 reads

Using the OBJECT_SCHEMA_NAME function to return the schema name

I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.   Read more...
By Additional Articles 2009/06/22 | Source: | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 2,718 reads

Using schema binding to improve SQL Server UDF performance

SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.  Read more...
By Additional Articles 2009/03/09 | Source: | Category: schema
Rating:  Rate this |   Briefcase | 3,694 reads
   Items 1 to 5 of 5