An occurrence of a database component. This can mean very different things depending on the platform.
4
votes
3answers
4k views
SQL Server 2008 R2: Problems after computer name change
I'm having a confusing problem after changing the computer name of a remote server hosting a local SQL Server instance.
Basically, a remote server was moved from one site to another. In order to ...
10
votes
3answers
532 views
What's the most effective way to duplicate an instance on SQL 2008?
We've got a simple database instance with just enough data in the databases to keep it useful, and we can use it for demonstration purposes, and I want to put a copy of it on my laptop so I can use it ...
19
votes
3answers
3k views
Is the SQL Server Express memory and CPU limit per instance?
If I have 8GB of RAM in a server and I run 4 instances of SQL Server Express, will the total memory limit used by SQL Server be 1GB or 4GB?
Would it be advisable to run multiple instances like this ...
