I would share my experience with SQL Server Management Studio (SSMS) install error – Setup is blocked due to another install currently running.
SQL SERVER – Poor Indexing Strategies – 10 Don’ts for Indexes
The most questions were around section Poor Indexing Strategies and that lead me to write about 10 Don’ts for Indexes. Let us talk about it today.
SQL SERVER – Disable Parameter Sniffing with DISABLE_PARAMETER_SNIFFING Query Hint
Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.
SQL SERVER – OPTION(FAST N) Hint and Performance
I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N).
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
What is the Replacement of DBCC DBREINDEX? – Interview Question of the Week #263
Question: What is the Replacement of DBCC DBREINDEX?
Answer: The answer to this question is very simple.
Here is the syntax:
SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5
I have written a few blogs where I explained a few issues about the failure of listener creation failure in a cluster. Let us learn about it.
SQL SERVER – Row Goal and Performance
During the recent consulting engagement of SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.
SQL Server Performance Tuning Real-World Scenarios – Training Day at #SQLBits 2020
I am very excited to present my day long (pre-con) known as Training Day at SQLBits. SQL Server Performance Tuning Real-World Scenarios.
SQL SERVER – Best Practices for Dynamics NAV AX CRM
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.