Plan cache pollution or how important it is to properly define parameters in code

Recently I was involved in couple of cases concerning plan cache taking more than 20% of the SQL Server Buffer Cache and although there is no fixed threshold/best practices value, I noticed that there were a lot of identical statements getting cached. Effective plan caching is important for optimal performance on SQL Server and I…

0

Listing encrypted columns–AE learning series part 03

In the first two parts (part 1, part 2) we learned how to build our first application using Always Encrypted and import new or existing data in it. In the following post I want to give you some details on the available metadata for Always Encrypted. There are some changes in existing DMVs (such as…

0