SQLServer

The pain of Forced Parameterization in SQL Server

A few months ago I blogged about the challenges of Simple Parameterization in SQL Server. Today I want to continue this discussion by talking about Forced Parameterization in SQL Server. Forced Parameterization Simple Parameterization has a number of limitations in SQL Server. It will not happen if your SQL statements contain any of these: JOIN …

The pain of Forced Parameterization in SQL Server + read more

How to pollute your Plan Cache with parameterized SQL statements

Parameterization of your SQL statements is always a good idea. With parameterized SQL statements you are not able to pollute your Plan Cache – WRONG!!! In this blog posting I want to show you how easy it is to pollute your Plan Cache even with parameterized SQL statements. ADO.NET – AddWithValue ADO.NET is the part …

How to pollute your Plan Cache with parameterized SQL statements + read more