Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.
Remove Key Lookup – SQL in Sixty Seconds #194
Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.
SQL SERVER – Measure Index Performance
My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
SQL SERVER – Rebuilding Index with Compression
We can be Rebuilding Index with Compression even if it was originally not created with compressions. Let us learn how we can do it today.
SQL SERVER – Prevent Users from Changing Index
Many people like this blog post and asked me to follow up questions about whether this method can be used to prevent users from changing the index.
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.
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.