Over time, SQL has evolved and offers two distinct styles for performing JOIN operations: the old-style comma-separated join and the more modern explicit JOIN syntax.
SQL SERVER – Making Recursive Parent-Child Queries Efficient
One puzzle is finding out how many employees each manager is responsible for in a company. Let us Make Recursive Parent-Child Queries Efficient.
Avoid Join Hints – SQL in Sixty Seconds #172
Question: If they can change the join hints to improve the performance of the query. Well, the reality is that I always Avoid Join Hints.
SQL SERVER – Change Join Type for Query
“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!
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.Â
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.