Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.
SQL SERVER – Poor Indexing Strategies – 10 Don’ts for Indexes
The most questions were around section Poor Indexing Strategies and that lead me to write about 10 Don’ts for Indexes. Let us talk about it today.
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
SQL SERVER – Simple Example of Batch Mode in RowStore
During Comprehensive Database Performance Health Check, I had a pleasure to demonstrate to customers a Simple Example of Batch Mode in RowStore.
SQL SERVER – Sample Script to Check Index Fragmentation with RowCount
Let us see a script built for one of my clients of Comprehensive Database Performance Health Check to Check Index Fragmentation with RowCount.
SQL SERVER – An Index Reduces Performance of SELECT Queries
Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete and meaningful to you.