Added by on 2014-05-15

Aaron Bertrand and Kevin Kline discuss some of the advantages for specifying the schema when creating, altering and referencing objects. They discuss how specifying a schema can affect performance and how important it is for security. They also use demos to illustrate the importance.

Category: Quick Tips    Tags: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *


1 Comment

  • Lance Andrewes 4 years ago

    Just last week a young SAS developer told me she was using SQL in preference to SAS PROCs when working with our SQL Server databases, because “SQL is so easy”. What you don’t know can hurt you. Thank you for another video that reinforced why we should always specify the schema.