All Forums Database
j355ga 100 posts Joined 12/05
23 Oct 2006
RoundHalfwayMagUp

We are considering changing this system setting to TRUE in a new financial data-warehouse. Are there any known issues setting this to TRUE? I don't need a discussion on the benefits etc....I just want to know if anybody has reported any bugs or problems with it.Thanks

Jeff
Fred 1096 posts Joined 08/04
24 Oct 2006

Not aware of any "bugs". If you have any tables with PPI where the partitioning expression includes DECIMAL calculations, you need to ALTER TABLE ... REVALIDATE PRIMARY INDEX WITH {DELETE|INSERT} after you change the value of this setting.

You must sign in to leave a comment.