Clients hired me to help with the Comprehensive Database Performance Health Check. We will talk about a very Confusing Story of CPU of Task Manager.
SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query
I was asked a very interesting question about statistics TIME and IO for SQL Server Management Studio, let us discuss that in today’s blog post.
SQL SERVER – Recompile Stored Procedures Two Easy Ways
At that point, I realized that I should have a blog post that explains to easy way to recompile stored procedures. Today, we will learn about 2 methods.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.
SQL SERVER – 5 Resources from SQLPASS 2019 – Seattle
I presented a session on Query Optimizer. In this blog post, we will see 5 important resources related to my session at SQLPASS 2019.
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.