Archives for April 2015

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance

Great topics for further reading about tuning SQL Server performance: Exploring SQL Server 2014 SELECT INTO Parallelism Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO operations. Parameter Sniffing, Embedding, and the RECOMPILE Options 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 … [Read more...]