November 2, 2009 at 9:28 pm
We often use dbo as the default schema. What would be the benefit of creating several other schemas and how can they be used effectively to improve SQL Performance.? Could you share any examples from your working environment, that has made a difference for you?
Thanks
November 11, 2009 at 1:24 am
Schemas can be used to simplify permissions for different users. For example, you could have schemas from Sales, Purchasing, Inventory; and the users in those departments could be granted the necessary permissions on those schemas as appropriate had have access to just the tables in the respective schemas.
We use schemas in our data warehouse staging database to identify the source systems for the data we import, so it keeps the different systems organized and if there happens to be tables with the same name, there isn't a conflict.
November 13, 2009 at 9:24 am
Is there performance impact when queries have to do multiple joins between different schemas?
November 13, 2009 at 9:32 am
Haven't seen any performance problems.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply