How parameter datatypes can effect caching

Published 12 July 09 07:00 PM | MartinBell

Plan caching is something that most DBAs would probably never look at until it becomes a problem on a live system. I thought this recent post by Simon Sabin on his blog was very interesting, as it shows that something which may seem so insignificant during developement could have a huge adverse effect.

I tested this myself and found that if you try the collation solution with a database_default collation the problem does not occur, which may be a more portable solution. If you use a UDT equivalent to nvarchar(max) the problem will still occur.

Filed under:


No Comments

This Blog

SQL Blogs