SQL SERVER – Which Settings Change in sp_configure Needs Restart to Take Effect?

Learning one new thing every day keeps me passionate about my job. Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check and found some non-default values in sp_configure.  They asked me – Which settings change in sp_configure needs restart to take effect? Do we need to remember the values?

Read More

SQL Authority News – Free Performance Tuning Videos

SQL Server Performance Tuning and Optimization is how I earn my bread at home. Lots of people often ask if I will be happy to teach them my SQL Server Performance tuning tricks and my answer is very simple – of course. I am always willing to help people learn about SQL Server Performance Tuning if they are willing to learn about the subject. I have created some Free Performance Tuning Videos.

Read More