During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
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.
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 – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards
While working together we figured out one of the many issues was the priority boost server configuration. Let us talk about it a bit more in detail.
SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.