Archive for December 2021
Memory – How to Find when Excess is a Bad Thing
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue.
Read MoreOwner is Missing in the GUI – An Easy Fix
In this article, I will share an oddity that happens when the database owner is seemingly missing.
Read MoreStatistics Auditing to make you Omniscient
Statistics in SQL Server, love them or hate them, are essential to good performance. Statistics help to drive execution plan selection and thus can have quite a profound impact. If you have bad stats, you can end up with a very poor plan. Conversely, good stats can help the optimizer in selecting an optimal and…
Read More