What is parameter sniffing in SQL, and how do you resolve performance issues caused by it?