Default instance VS Named instance

If you have a choice to pick default instance or named instance, which one
will you choose and why ?
One saying is named instance provides more descriptions
to the DBAs if they need to managed many DBs.
Hi
Having multiple instances on a single machine will use up additional
resources, but there are valid reasons to do so, including ones related to
secutity an access. Having a single named instance on a machine, is probably
a personal preference, although you will always need to know and specify the
instance name when connecting to it.
I seem to remember that MSDE will only install as a named instance, but can
find where I saw it!
John
"Angus" wrote:

> If you have a choice to pick default instance or named instance, which one
> will you choose and why ?
> One saying is named instance provides more descriptions
> to the DBAs if they need to managed many DBs.
|||MSDE can run under and be installed under either. The problem is that it
typically is installed where another instance is already running.
Some applications can not connect to a named instance, the "\" in the server
name throws them off for some reason.
Other than that, it makes no difference. If you are running multiple
instances, you have to have a way to distinguish them and their respectie
binaries and services, thus the concept of a named instance to begin with.
Sincerely,
Anthony Thomas

"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:EF5564B6-0087-408C-9DE4-B9792CF7BB31@.microsoft.com...
Hi
Having multiple instances on a single machine will use up additional
resources, but there are valid reasons to do so, including ones related to
secutity an access. Having a single named instance on a machine, is probably
a personal preference, although you will always need to know and specify the
instance name when connecting to it.
I seem to remember that MSDE will only install as a named instance, but can
find where I saw it!
John
"Angus" wrote:

> If you have a choice to pick default instance or named instance, which one
> will you choose and why ?
> One saying is named instance provides more descriptions
> to the DBAs if they need to managed many DBs.