I love query tuning and performance tuning projects. In one of the recent Comprehensive Database Performance Health Check my client had a very interesting scenario where their queries were running pretty fast earlier but gradually started to run slow and eventually started to take over 10 minutes to execute. They reached out to me to tune their slow running query. While looking at the query execution plan, there is a big key lookup operation which was actually slowing down their query. I decided to create an index with include column on that table and resolve this issue.
Puzzle – Datatime to DateTime2 Conversation in SQL Server 2017
Earlier last week, I was presenting various questions about SQL Server 2017 at PASS in Seattle. However, during one of the session, I was fortunate to meet SQL Server Expert Christopher Savage. He shared a very interesting puzzle with me. I have been trying to solve the puzzle for a while, but I have no answer for it. Let us see the puzzle about DateTime2 Conversion in SQL Server 2017.
SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance
There have been many questions in my mailbox asking about exact steps to change the windows cluster and SQL failover cluster IP address to the new VLAN. In this blog, I would outline the steps which are needed to perform this migration.
Video – Bert & Pinal Troubleshoot a Slow Performing SQL Server
Earlier last week, I had the opportunity to attend my 10th SQL PASS. Yes, It has been 10 years since I have been visiting the PASS conference. This year, I had the opportunity to present 1 pre-con, 2 general sessions, 1 lightning talk. I really had a busy time at SQLPASS but along with the sessions, the highlight of the event was a video I recorded with Bert where we discussed troubleshoot a Slow Performing SQL Server.
Practical Real World Performance Tuning – 50% Discount for 15 Days
Practical Real World Performance Tuning – 50% Discount for 15 Days
SQL SERVER – Initializing the FallBack Certificate Failed With Error Code: 1, State: 20, Error Number: 0
One of my clients came with an issue with SQL Server startup. As per them, they just changed the password of SQL Server Service account using the configuration manager. In this blog we would learn about how to fix Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0 during SQL startup.
Does Sort Order in Index Column Matters for Performance? – Interview Question of the Week #199
Question: Does Sort Order in Index Column Matters for Performance?
Answer: Wow, it has been a long time since I have heard this question and the matter of fact, I have never blogged about this subject on this blog. I have received this question during my recent Comprehensive Database Performance Health Check.