Yesterday we looked at how unused indexes can muck up the buffer pool, because writes to them will bring pages in.
Today we’re going to look at how unused indexes add to locking problems.
Hold My Liquor
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.