One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
Azure Free Courses at Pluralsight
I also work on SQL Azure, MySQL, MariaDB, PostgreSQL as well as Visualization areas. I am going to share details about Azure Free Courses at Pluralsight.
SQL Azure – Install Module Fails with Error
My client told me that they need help with an error related to Install Module on SQL Azure. Let us learn how we can fix the error.
Free All Pluralsight Courses for April 2021
Pluralsight is repeating the history again by announcing all the courses for FREE access for April 2021. Yes, you read it a reality.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
SQL SERVER – Cached Data Per Object in Memory
“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
SQL SERVER – Disable Adaptive Joins
My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins.Â
Kali Linux Installation Error Fix: An installation step failed. You can try to run the failing item again from the menu, or skip it and choose something else
W made a huge change in the server and needed to reboot the environment, during that time I witness errors related to Kali Linux Installation.
SQL SERVER – Enable Adaptive Join
Let us learn how we can enable the adaptive join feature in SQL Server. I often discuss this during Comprehensive Database Performance Health Check.
SQL SERVER – Adaptive Threshold Rows
Today we are going to learn about what drives the decision to join Adaptive Join. Well, the answer is very simple – Adaptive Threshold Rows.