I would share my experience with SQL Server Management Studio (SSMS) install error – Setup is blocked due to another install currently running.
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 – 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 – Display Rupee Symbol in SSMS
Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.
SQL SERVER – SQL Server Agent Missing in SQL Server Configuration Manager
In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.
SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)
I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.