Long Grain vs Short Grain Rice

When is it best to use long grain rice and when short grain rice, like arborio?

From: Josie, Brussels

Long grain rice is ideal for salads and side dishes. Short and medium lenght grain rice is used for puddings and some dishes like Spanish paella, Japanese sushi or Italian risotto.

There is more information about rice varieties.