New answers tagged sql-server-2008-r2
Based on your requirements, there is no need for a new SQL Server instance As you don't need different SQL Server versions and your security and permissions requirements can be set on a single SQL Server instance, you can create a new database on the same instance Creating a new database on the existing SQL Server instance provides easier administration ...
If all they need is db_owner, then I'd recommend that you do this in your existing instance. Creating a new instance incurs the overhead of running two copies of all the SQL binaries. SQL works best when it can govern all the available resources of the server. Multiple instances are not aware of each other, and can end up fighting for available resources. ...
It depends on your scenarios, but as i know it is make sence to deploy new instance if the application require sysadmin or serveradmin roles, for example.
Top 50 recent answers are included