At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
Excel – Sum vs SubTotal – SQL in Sixty Seconds #167
Just like SQL Server, I work with MySQL, PostgreSQL, MariaDB, MongoDB, and Excel. Today we are going to see in excel which is about Sum vs SubTotal.
3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166
We will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP.Â
Get Memory Details – SQL in Sixty Seconds #165
My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.
CPU, Linux and Shutdown – 3 SQL in Sixty Seconds Video
Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions.
Get CPU Details – SQL in Sixty Seconds #164
I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.