Re: Replication Conflict Viewer crashes

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

From: Michael \(michka\) Kaplan [MS] (michkap_at_online.microsoft.com)
Date: 05/20/04

  • Next message: Jay A.: "Run-time error '-2147467259 (80004005)'" 
    Date: Thu, 20 May 2004 09:27:25 -0700

    "Bruce" <bruce@aristotle.net> wrote...

    > > How many fields in the table?
    >
    > There are 172 fields in the table.

    This would be the main source of there being a problem. Which is not to say
    it wouldn't still be a bug. But the bulk of the testing was done on much
    more reasonably sized (and often properly normalized) schemas.

    > The option to show only the
    > conflicting fields is selected.

    Note that this means the viewer has to load every item and compare them to
    see if they are the same or not. Depending on the complexity of the fields
    and the amount of change, the time it takes to "compare every item and
    display the changed ones" vs. "display every item" can vary in terms of
    which is more intensive.

    My advice would be to do some schema design, specifically to properly
    normalize the data, as a design that is so far from 3NF as to have tables
    with 172 columns in them is fraught with either unnecessary duplication,
    wasted space, and/or data inconsistencies which replication will only be
    hurt by. 

    -- 
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
  • Next message: Jay A.: "Run-time error '-2147467259 (80004005)'"

    Relevant Pages

    • Re: Graphics card driver issue
      ... (not too many extensions implemented). ... name of display::0.0 ... worse then nvidia's (not sure how the ATI compare to nvidia lately). ... Why did you have to turn off Cg for those cards? ...
      (comp.graphics.api.opengl)
    • Re: Apples 24" LED display
      ... Apple 24" LED Cinema Display. ... Neither can it compare to a new LED Samsung. ... I'm sure the LED Samsung compares very well to Apple monitors. ... XL2370 is slightly different from the Apple 24" LED Cinema Display. ...
      (comp.sys.mac.system)
    • Re: Excel 2003 - Hiding Columns Based on a Condition
      ... I replied with a long blurb and it didn't seem to post. ... I was able to make a list of the dates I will get paid. ... integer of the day and month and compare them to my integers (the 15th ... able to make one true statement and display a set of columns. ...
      (microsoft.public.excel)
    • Re: can Word 2002 compare documents?
      ... click Compare and Merge Documents. ... Select the original document, click the arrow next to Merge, and then do one of the following: ... To display the results in the currently open document, ... I would like to compare a OCR scanned document received from a publisher with the original Word document that was sent out to find the changes and differences between the two. ...
      (microsoft.public.word.newusers)