sql server - Dropping SQL foreign key on a live database -


would run issue if tried dropping foreign key constraint on live sql database? want make sure there's no reason take database offline before doing this.

dropping foreign key on live databases can done online without impacting users. may run data quality issues though, guess foreign key in place reason.


-

Popular posts from this blog

debugging - Reference - What does this error mean in PHP? -

what this? this number of answers warnings, errors , notices might encounter while programming php , have no clue how fix. community wiki, invited participate in adding , maintaining list. why this? questions "headers sent" or "calling member of non-object" pop on stack overflow. root cause of questions same. answers questions typically repeat them , show op line change in his/her particular case. these answers not add value site because apply op's particular code. other users having same error can not read solution out of because localized. sad, because once understood root cause, fixing error trivial. hence, list tries explain solution in general way apply. what should here? if question has been marked duplicate of this, please find error message below , apply fix code. answers contain further links investigate in case shouldn't clear general answer alone. if want contribute, please add "favorite" error message, warning or notic...
Read more

Perl "Out of memory!" when processing a large batch job -

a few others , happy maintainers of few legacy batch jobs written in perl. 30k lines of code, split across maybe 10-15 perl files. we have lot of long-term fixes improving how batch process works, in short term, have keep lights on various other projects depend on output of these batch jobs. at core of main part of these batch jobs hash loaded bunch of data collected various data files in bunch of directories. when these first written, fit nicely memory - no more 100mb or so. things of course grew on years, , hash grows box can handle (8gb), leaving nice message perl: out of memory! this is, of course, poor design batch job, , have clear (long-term) roadmap improve process. i have 2 questions however: what kind of short-term options can at, short of throwing more memory @ machine? os settings can tweaked? perl runtime/compile flags can set? i'd understand why perl crashes "out of memory!" error, opposed using swap space available on machine. for refe...
Read more