Anybody with tips or experience dealing with this double life?
Sure. I will write in terms of girlfriends but probably half of it also applies to SP's.
First of all, keep them separate. If you have a wife and a girlfriend, say, there should be little or better yet, no overlap in the social circles of the wife and the girlfriend. Don't live a double life with your wife's friend. And while the girlfriend needs to know about he wife (because you will NEED her co-operation) do not under any circumstances give the girlfriend have the wife's contact information--so, don't give out your home number, or anything like that.
Second, set clear priorities. Wife always comes first. Girlfriend must accept it. If you have a plan with the girlfriend, and wife has a crisis at work, you drop the girlfriend to support the wife. The girlfriend should have the same priority, as, say, playing tennis with your friends. Important to you, but not so important that you can't drop it to be there when you're needed.
Third, do not make up crazy stories. You won't be able to keep your story straight. What you say to your wife has to be 99% the truth. If you make up crazy stories to explain your behavior you WILL get caught. Ideally absolutely everything you say is true. It should ideally only be a matter of leaving out a few salient details. For example if your story is that you're working late at the office, you should be working late at the office--really. Out of 4 times you claim to be doing it, it should be true 4 times. Just that one of the 4 times you only worked half as late as you said...
Fourth, be very aware of your information trail. What computer or phone do you use to contact your double life? Make sure that your wife never has access to it. Most common way anybody ever gets caught is the phone was lying on the night table and wife saw the text message come in from the girlfriend.
Consider buying a 2nd sim, and swapping it in to talk to the girlfriend. Make sure the phone numbers and messages are deleted from your phone when you're done. This is better than having a second phone, because it's a little hard to explain why you have the second phone when the wife finds it in the glove compartment. SIM card can be more easily concealed, and explained away ("Oh that's old, from my last phone"). Learn about SIM locking, make sure the SIM is locked ("I don't even remember that code, just throw it out!").
Be aware of smells. If wife is going to be able to smell you when you come home, make sure you can have a shower somewhere before you get home, and explain it. Being active in a gym with late hours is very useful, as is having a shower at your work if you can. Or shower at her place. Be aware of the soap you use--buy the same soap you have at home, and make sure it's available. Don't come home smelling like somebody else's soap.
Never under any circumstance bring your girlfriend to your home, or introduce her to any friends who are also friends of your wife.
Understand what areas your wife and her close friends frequent, and avoid those areas. Keep your double life out of public places as much as possible, unless you are able to get away to a different town or city, or you're very sure, for some reason, that your wife and her friends won't frequent the locations you visit. Crossing races help here--if your wife is Italian, and your girlfriend is Korean, it's unlikely your wife or her friends will be hanging out in the Korean karaoke bar, say.
This part isn't achievable for everyone, but some can do it: Become a better liar. In order to do this, make sure your wife has a "tell" that she knows, so that she knows when you are lying. Allow yourself to be caught in all sorts of large and small lies based on this tell. Make sure you can suppress it when it matters. Do not suppress it any other time. Make it natural. Maybe she believes you can't help smirking a little when you lie. Do not use this on a regular basis (see the 99% rule above). This is your fall back only, you shouldn't HAVE to lie if you are doing things right.
And this is critical: Be aware of how you treat your wife when you come back from the double life. Do not treat her nicer than usual (because you are guilty) or worse than usual (out of spite). If you have EITHER of those emotions, and treat her in any way different than any other day, then sorry, but a double life is not for you.
While the #1 way people get caught is through the text message, email, poor lie, or other slip, the #1 way that a person becomes suspicious of their partner is a noticible and unexplainable change in in their behavior. MORE loving or LESS loving. Either way, she will wonder, what is up. Be aware of how you act on a normal day, and check that you aren't acting any different on special days.