Continuity mistake: After Carrie has sex, Kurt's grey underwear way below his groin (to protect his modesty) is briefly seen. (00:12:16)
Revealing mistake: When Carrie bumps into Mr. Big and her purse falls, watch the people in the background carefully. Many of them are watching the couple talk and interact with each other. On a busy New York street nobody is going to pay attention to two people having a conversation. Apparently all these people were watching the shooting of the scene.
Continuity mistake: While having coffee with Carrie, Skipper cries "I hate that word!" and raises his hands next to his head. A shot later they are not close to the head.
Continuity mistake: When Miranda is drinking with Skipper, she brings her cocktail close to her face twice.
Continuity mistake: Charlotte gets in a taxi with his date and the cab drives fast and leaves. Inside the cab, it drives really slow. It even gives the impression of being still for a couple of seconds.
Continuity mistake: When Sam is smoking a cigar with Big, a woman suddenly appears right behind her.
Other mistake: When Carrie opens the newspaper to read her column, the same paragraph is repeated at least twice.
Continuity mistake: When Miranda recalls the Linda Fiorentino movie, Carrie's right arm swaps between holding a cocktail or resting empty handed by her lap.
Continuity mistake: When the couple is practising golf, the sky has dusk light, but in the immediate shot it is bright blue.
Continuity mistake: Miranda says "I'll raise your thighs and give you a chin", and Carrie swaps from eating a spring roll with her head lowered to having her head raised. (00:05:49)
Continuity mistake: Miranda picks food with the chopsticks, then exactly one second later the food is gone and she is talking. Too fast for her to take it to her mouth, chew it and swallow it, for the scene takes place in real time. (00:06:00)
Continuity mistake: Sams shays she looks good and Miranda replies "you paid enough for it" and puts her chopsticks down. A shot later they're back in her hand and she is picking food. (00:06:03)
Continuity mistake: When Carrie arrives backstage at the fashion show, she's wearing a black dress with a long jewelled necklace that is wrapped once around her neck and hanging down on both sides of her chest, like a scarf. When the fashion show starts, the necklace strands are tied together in a big knot/wrapped around her neck more. Then, when she's about to get in a cab home, they are untied/hanging down again.
Visible crew/equipment: After Stanford tells Derek he's going to be a star, the steadicam operator is reflected on the mirror behind.
Continuity mistake: When Big arrives at the party Carrie is eating a snack, with a remaining one on her hand. Big sees her and she's eating another snack, which leaves her with zero food. Half a second later there's a wide shot and not only is she not chewing the previous bite, but 2 snacks have suddenly appeared on her hand.
Visible crew/equipment: When Stanford and Carrie walk backstage with the models, check the reflection on the glass and you'll see: the boom mic operator, camera and, best of all, a group of technicians crouching on the floor, failing to hide and moving around when Carrie and Stanford walk around.
Continuity mistake: When the artist stops using the airbrush he holds it with his left hand. A shot later it's in his right hand where he drops it off.
Continuity mistake: When Carrie exits the club there's a woman with a bulky silver wig behind her. When the shot changes the woman has moved several meters back and is walking by again.
Visible crew/equipment: When Big arrives at the cafe a moving boom mic is perfectly visible on the glass behind with an arm and a hand moving it.
Continuity mistake: Before dinner, Miranda holds the candles with her right hand. Then puts them in her left hand. A nanosecond later, from a different angle. She is leaving them on the table using her right hand. She couldn't have used her left hand for she is holding the napkins and they would've fallen down.
Answer: A popular brand of sexual lubricant. See http://www.k-y.com/index.jsp.
J I Cohen