I presented a session on Query Optimizer. In this blog post, we will see 5 important resources related to my session at SQLPASS 2019.Â
SQL SERVER – Error 17182: Unable to Initialize SSL Support. The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm
Unable to Initialize SSL Support. The client and server cannot communicate, because they do not possess a common algorithm
How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250
Question: How to Write INNER JOIN Which is Actually CROSS JOIN?
Experienced this question another day while working with a client.
Analyzing SQL Server Query Plans – Watch on Pluralsight
I have received some really great comments and feedback about this course. This entire week, I discussed various aspects of the query plans.
Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5
Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to configure Azure SQL Database Performance Insight.
Compare Estimated and Actual Query Plans and Related Metadata – Analyzing SQL Server Query Plans – Part 4
Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to Compare Estimated and Actual Query Plans.
Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss how to Create Efficient Query Plans Using Query Store.
Identify Poorly Performing Query Plan Operators – Analyzing SQL Server Query Plans – Part 2
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Identify Poorly Performing Query Plan Operators.
SQL SERVER 2019 is Released!
SQL SERVER 2019 is released today. You can get started immediately with it by downloading appropriate version for your system.
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.