Here's two ways:

1. Change the material from "World Standard" to "Object Standard" and then rotate your object.

or

2. (see 2nd illus. for this one) Edit the bump and color functions (though on this sand material only bump is really important, I think) and click on "rotate" at the bottom. Change the z value to 90 degrees or whatever value you need.