Make div stay at bottom of page’s content all the time even when there are scrollbars

This is precisely what position: fixed was designed for:

#footer {
    position: fixed;
    bottom: 0;
    width: 100%;
}

Here’s the fiddle: http://jsfiddle.net/uw8f9/