Newbie question on meaning of icon...

Hi! I have "inherited" a SQL server that I am quickly trying to get up to
speed on administering. There are several db's on the server. If I look at
the db's in enterprise manager one of them has what looks to be a "shared"
icon beside the db name. It looks just like the other db icons but has that
"share" hand underneath. What does this symbolize and how do I make
adjustments to this setting.
Sorry for being so obtuse! Thanks for the help!
-alex-The 'sharing' hand means the database has been enabled for replication.
First, you read BOL (Books On-Line) and understand what replication is and
hw it works before you make any adjustments.
IMHO, your first concern should be backup and recovery. Next comes
space/performance management and monitoring. Last comes changes and
improvements.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bairda" <bairda@.discussions.microsoft.com> wrote in message
news:F5139783-2191-442A-9584-04C743848493@.microsoft.com...
> Hi! I have "inherited" a SQL server that I am quickly trying to get up to
> speed on administering. There are several db's on the server. If I look
at
> the db's in enterprise manager one of them has what looks to be a "shared"
> icon beside the db name. It looks just like the other db icons but has
that
> "share" hand underneath. What does this symbolize and how do I make
> adjustments to this setting.
> Sorry for being so obtuse! Thanks for the help!
> -alex-

newbie question on indices

Hi all,
When one creates a PF or a FK, does SQL server automatically create the
needed indices for optimum speed, or do I have to create them myself in
order to speed join up.
ThanksSQL Server will create indexes for PK and UQ constraint, as they are needed
to quickly find if you
try to insert a duplicate. The PK index is clustered by default and can be o
verridden. SQL Server
does *not* create index for a FK, and such an index can very much improve fo
r instance join
operations (as joins are often done based on PK-FK relations).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Robert Bravery" <me@.u.com> wrote in message news:e8%23gnSPQGHA.3192@.TK2MSFTNGP09.phx.gbl..
.
> Hi all,
> When one creates a PF or a FK, does SQL server automatically create the
> needed indices for optimum speed, or do I have to create them myself in
> order to speed join up.
> Thanks
>|||Thanks
Robert
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O1jbIVPQGHA.3848@.TK2MSFTNGP12.phx.gbl...
> SQL Server will create indexes for PK and UQ constraint, as they are
needed to quickly find if you
> try to insert a duplicate. The PK index is clustered by default and can be
overridden. SQL Server
> does *not* create index for a FK, and such an index can very much improve
for instance join
> operations (as joins are often done based on PK-FK relations).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Robert Bravery" <me@.u.com> wrote in message
news:e8%23gnSPQGHA.3192@.TK2MSFTNGP09.phx.gbl...
>sql