SQL Server Performance

Schema implementation

Discussion in 'Getting Started' started by reethu, Dec 9, 2009.

  1. reethu New Member

    Hi
    SOme one can provide advantages and disadvantages in implementing Schemas in prod environment.
  2. shashank sharma New Member

    Schema in SQL Server is an object that conceptually holds definitions for other database objects such as tables,views,stored procedures etc. The main advantage of creating a schema is that you can grant permissions to database objects by a single CREATE SCHEMA statement.Objects belonging to a schema are said to be schema bound.When creating an index view,the view has to be schema bound.Base objects such as a table or a view cannot be dropped when a schema-bound object such as a view is created on it.
  3. satya Moderator

    From the BOOKS ONLINE (BOL): A schema is a container that holds tables, views, procedures, and so on. It is inside a database, which is inside a server. These entities fit together like nested boxes. The server is the outermost box, and the schema is the innermost box. It holds all of the securables listed below. But it cannot hold another box.
    http://msdn.microsoft.com/en-us/library/ms190387.aspx
    http://www.sql-server-performance.com/articles/dba/authorization_2005_p1.aspx
    http://blog.sqlauthority.com/2009/09/07/sql-server-importance-of-database-schemas-in-sql-server/
    For sure there are no disadvantages of using this way.

Share This Page