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.
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.
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.
SQL SERVER – Applying Query Hints to Views
I totally agree that it is not possible to apply query hints to views inside the view. It will give you an error. However, there is a workaround.