Here are the two holds I know most but there are a few variations out there as well. On the stick is known as 'French' and in the Frog is usually called 'Italian'.
Having a good bow helps. I would say the bow itself is more important than the grip. Why? Because even with the best Grip, you can't make a weak bow work well. Better maybe but it will cause more bad habits to form than you can afford the time to correct.
Good Bow, good bow hold, good bow technique, good bass that responds well to a bow, good strings and a good teacher. All this adds up to good music that will be more fun to play than punishment. Playing on bad gear is like getting punished. It's no fun and no matter how hard you work, you still can't get it as good as you would like.