Re: Database Replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ryan,
I agree with Adam, but just to clarify, if you mean queries applied to the
publisher then there' s no issue, but if the query is to the subscriber, you
might experience the normal blocking issues. The new snapshot isolation
level can be of use here. I have no stats regarding the performance
comparison between database mirroring and replication as yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .




.

Relevant Pages

  • RE: filtering table data on a form with combo boxes
    ... "Adam" wrote: ... I'll leave it at this so far, to see if i am helping, and to ensure you can ... below the combo boxes. ... the query I get an error message "compile error. ...
    (microsoft.public.access.gettingstarted)
  • Re: Nettuno 3 running strangely - advice needed
    ... account enquireies press 3....world peace press 8, repairs press 9. ... if you have a query about the status of your repair press 1. ... jingo bells.. ... Adam. ...
    (alt.horology)
  • Re: Nettuno 3 running strangely - advice needed
    ... if you have a query about the status of your repair press 1. ... jingo bells.. ... Adam. ... You've been placed in the queue and the first available consultant ...
    (alt.horology)
  • RE: ADAM AND ASP.NET
    ... > I configured 3 machines on the same domain ... > Windows 2000 Server ... > ADAM ... > From machine A I can successfully execute the following query to return ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM Security Logging
    ... the User column of the ADAM instance event log for a native ADAM ... To get a security log audit when a native ADAM user connects to ... > return a limited number of entries per query. ... This works great when an AD account ran the query, ...
    (microsoft.public.windows.server.active_directory)