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.
SQL SERVER – Table or View – OBJECTPROPERTY
Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out.
Find Expensive Queries – SQL in Sixty Seconds #159
Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries.
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.
SQL SERVER – Flush Data from Memory to Disk
One of my clients asked me how to Flush Data from Memory to Disk during a recent consulting engagement Comprehensive Database Performance Health Check.