Great topics for further reading about tuning SQL Server performance:
Parameter sniffing is a term used to describe the processes by which SQL Server attempts to reuse execution plans where certain parameters might frequently change. If you’re only familiar in passing with the term, it probably has negative connotations for you. But parameter sniffing is merely a behavior, which is neither always bad nor always good in and of itself. Read this interesting article by Paul White (b|t), and be sure to read the lively discussion that follows.
Erin Stellato (b | t), of SQLSkills.com, is back with another great read. This time she’s covering performance benefits that come from partitioning and in which cases partitioning is not going to provide a performance boost.