Should a website always have a sticky footer

Trend goes that developers want to have a sticky footer in their site. If the content is well below the view port, the footer goes out of screen. Otherwise it is visible at the bottom of the screen.

If I do not make the footer sticky then if the content height is less than that of the view port , the footer will be visible just below the content. And if the content is of much height then the footer will go down the view port.

Is a non-sticky footer a good design from UX perspective ?