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
Today I want to talk about the server option Optimize for Adhoc Workload and how it affects your Plan Cache in SQL Server. Before we dig into the details, I want to show you how SQL Server can reuse cached execution plans. Execution Plan Reuse Every time that you submit a query to SQL Server, …
How “Optimize for Adhoc Workload” impacts your Plan Cache + read more
Today I have uploaded the 26th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Repeatable Read in SQL Server. Thanks for your time, -Klaus
In today’s blog posting I want to talk about a very important topic in SQL Server that always confuses people when they first work with SQL Server. It is about the difference between the Primary Key constraint and the Clustered Index. What is a Primary Key? Let’s talk first about the Primary Key constraint itself. …
In today’s blog posting I want to show you a undocumented function in SQL Server, and how you can use that function to find out on which pages records are stored. %%lockres%% The undocumented function that I want to show you today is called %%lockres%% and has to do with the locking implementation of SQL …
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.
