After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.Â
SQL SERVER – Query Cost 100%
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.