This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
Indexing for Delete – SQL in Sixty Seconds #197
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.