Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
SQL SERVER – Database Giving Error While Setting Single_User Mode
Let us see a quick workaround in this blog post about an error related to Database Giving Error While Setting Single_User Mode.
SQL SERVER – Disable Statistics Update for a Single Table
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?
SQL SERVER Management Studio – Word Wrap
One of the requests I usually do to my client when they are using SQL Server Management Studio is around Word Wrap. Let us learn about it today.
SQL SERVER – 3 Different Ways to Set MAXDOP
I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
Priority Boost and Performance – SQL in Sixty Seconds #131
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.