Parameter sniffing is a great feature of SQL Server that helps execute queries with less CPU and memory consumption, but sometimes can go bad on us. Meaning our queries can take longer execution times, use more IO and CPU. Why does this happen and how to deal with it I will describe in this blog post.