Multiple Plans for an "Identical" Query
I discuss a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.
Monthly Archives: November 2014
Over 40 queries to find SQL Server tables with or without a certain property
Tip : Over 40 queries to find SQL Server tables with or without a certain property
November 2014 Cumulative Updates for SQL Server 2012
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...
Verify the databases a SQL Server login can see – and why
Tip : Verify the databases a SQL Server login can see – and why