DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.
Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.