How to tune a T-SQL with Query Cost 100%?
This is indeed an interesting question and I have received during Comprehensive Database Performance Health Check.
Experience – My Very First YouTube Live
Today I am going to share my experience with my very first YouTube Live. I realized that there is a lot of improvement required in my efforts, and I also need to bring some more fineness in my presentation. Let us discuss that in detail.
SQL SERVER – Using CASE Expression in Default Value
It is not possible to use CASE Expression in Default Values when you add a new column. I hope this answers the question. However, there is a workaround.
Queries Using Specific Index – SQL in Sixty Seconds #180
The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
Announcing First Live – Fixing SQL Performance Troubles
Lots of people often ask me that they would like to connect with me Live and ask questions. I am Announcing First Live – Fixing SQL Performance Troubles.
SQL SERVER – Find Instance Name for Availability Group Listener
How to Find Instance Name for Availability Group Listener? I was recently asked this by DBA at Comprehensive Database Performance Health Check.
SQL SERVER – Finding Queries Using Particular Index
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.