SQLServerCentral.com Content tagged T-SQL, Schema

Which Statement will execute sucessfully

Fri, 07 Dec 2012 07:00:00 UT

Copy One Schema to Another Schema

Wed, 31 Aug 2011 06:00:00 UT

This script copies one object in another multiple schema.

default schema trouble

Wed, 28 Jul 2010 06:00:00 UT

Using the OBJECT_SCHEMA_NAME function to return the schema name

Mon, 22 Jun 2009 06:00:00 UT

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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Using schema binding to improve SQL Server UDF performance

Mon, 09 Mar 2009 06:00:00 UT

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.