Re: PROBLEM: Cannot rebuild index!!

>Couldn't you just set the constraint to novalidate,prior to the load,
>and enable validate exceptions into .... ?
>Then you would have prevented all this fuss.

Quite possibly. Sadly, I'm 1 year into an environment that has been
humming along for several years prior - so reinvention of the process
will likely not be received all that well. However, if this case can be
used as an object lesson, perhaps some retooling of the process would
at least be considered.

.

Relevant Pages

  • Re: How to set FILLFACTOR
    ... All the datawarehouse tables do not have any constraints. ... > delete all indexes, fill the table, recreate the indexes. ... > disable constraint validation, load the table, defrag your indexes after ... > disabling the constraint like foreign key check etc... ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: ignoring an error message
    ... Joseph wrote: ... I am trying to use the load of files in a certain category in order ... to use them as constraints for my current category optimization. ... develop codes for the optimization without the constraint) ...
    (comp.soft-sys.matlab)
  • ignoring an error message
    ... I am trying to use the load of files in a certain category in order ... to use them as constraints for my current category optimization. ... develop codes for the optimization without the constraint) ...
    (comp.soft-sys.matlab)
  • Re: David Cameron on drugs
    ... >> lamer. ... >> Well, yours actually, seeing as you're the only one making a load of ... Prev by Date: ...
    (uk.politics.misc)
  • Re: Video: Nadals ankle inury
    ... What a load of fuss over nothing. ... as injuries like this can really come back and haunt you ...
    (rec.sport.tennis)