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.
How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093
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.
How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092
Question: How to Install SQL Server 2019?
Answer: This is one of the unique blog posts in the history of SQLAuthority, it is merged blog post.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Today we are going to discuss how we can change the configuration value of the Boost SQL Server Priority with SSMS version 18 onwards.