http://support.microsoft.com/kb/321363

read this article

this time it makes one copy

next time if i do it makes other copy (3rd copy)

can u clarify?

old hand:thanks for ur information

in my server i can not select particular instance for per monitor counter

can u please guide me in how to use perf monitor

even though it takes long time

I came to know only transactional replication is best suited as log shipping has delay of getting data to secondary instance.my doubt is can we create user and...

not only read permissions but he should be able to write.

I guess replication and transaction log shipping are options but which one is best? can i give all permissions to...

i mean set deadlock priority HIGH before the query is the only solution for this problem

I mean even when we run update stats, there are stasts that will not be updated?

Because when i ran update stats on a table all are updated except one. it...

oh there are certain tables which autoupdate statistics are not necessary?

i got the stats name and stats update date but one of the statsupdate date is feb2011 but rest are showing the date when i ran the job. This result...

Is this Sp reorganizing indexes?

how to check stats date fro the tables?

how do we know which stats are not part of indexes?

How to make sure Autoupdate statistics is ON in Rebulding index step