There would be no more earthquakes or volcanic eruptions as the earth's plate are the cause of both these occurrences.(which can be seen as a positive)
However, the plates allow the earth to cool when they move because they cause heat loss.If the plates were to stop moving the earth would have to loose heat another way and since we cant tell how this would happen, it could be very dangerous.