DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.
SQL SERVER – Index Scans are Not Always Bad
Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.
SQL SERVER – Table Variables, Temp Tables and Parallel Queries
I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
SQL SERVER – 3 Questions Answered on One Query Many Plans
Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.
SQL SERVER – Same Result Same Query Plan – Different Entry in Cache
The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.
SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
Video Resources for 9 SQL SERVER Performance Tuning Tips
I had blogged about 9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168. The video got an amazing response and lots of comments.