Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
Let us see a quick workaround in this blog post about an error related to Database Giving Error While Setting Single_User Mode.
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
SQL Server 2019 is very easy but the real challenge is to uninstall SQL Server 2019 instance. Let us learn how we can do that in video.