This week we're going to take a look at issues with filtered indexes. This feature was a very welcome addition in SQL Server 2008 and has enjoyed widespread usage if conversations on twitter and forums are any indication. But their implementation is not perfect - bugs in SSMS and numerous restrictions on their use have certainly reduced their ...

Control over procedure cache We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as ''won't fix'' but it's been shown time and time again that in some cases we need this extra knob. #293188 : Amount of RAM for ...