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.
One Scan for 3 Count Sum – SQL in Sixty Seconds #178
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).