The pain of Forced Parameterization in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) A few months ago I blogged about the challenges of Simple Parameterization in SQL Server. Today I ...

Read more

How to pollute your Plan Cache with parameterized SQL statements

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Parameterization of your SQL statements is always a good idea. With parameterized SQL statements you are not ...

Read more

How “Optimize for Adhoc Workload” impacts your Plan Cache

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I want to talk about the server option Optimize for Adhoc Workload and how it affects ...

Read more

Primary Key vs. Clustered Index

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) In today’s blog posting I want to talk about a very important topic in SQL Server that ...

Read more
SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top