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.
The Monthly Mentor Returns 2021 – 3 Webcasts
I have recently built three FREE webcasts under the monthly mentor returns 2021 series for Quest. 2 of the earlier performed webcasts.
SQL SERVER – List Expensive Queries – Updated March 2021
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.