Hey there tigerlady,
Though it may be tempting to have a couple beers or a shot before the needlework begins, it's best just to gut it out. Drink when you get home, in moderation if at all, and enjoy the endorphins in the meantime. Alcohol flushes the capillaries near the surface of your skin, so you bleed a lot more. This bleeding can flush the ink and reduce the quality of your tat, not to mention make it difficult for the artist to work. If they know you've been drinking, most good artists who care about their reputations will turn you away. I mentioned endorphins; your body will naturally produce pain killers for you. I usually feel pretty high when I leave a long ink session.
As for pain, it's all relative. The closer to the bone or nerve centers, the worse off you are. For example, the back of the knee, near the spine, or top of the foot are some of the more painful places to get inked. It also depends on the artist. When my wife and I got our wedding bands done a few years back, the artist was really good but the most PAINFUL guy I'd been to. He pressed really hard on the needle, which resulted in good definition, but it felt like I had slid on tarmac at 60 miles per. Usually it just feels like a mild rug burn.