Last Updated on August 29, 2020 by John Morehouse There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that this blog will be discussing, trace flag 4199, the database scoped configuration […]
Using LAST_QUERY_PLAN_STATS in SQL Server 2019
Last Updated on July 28, 2020 by John Morehouse In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows data professionals to have better and faster queries while simultaneously minimizing effort. […]