During Comprehensive Database Performance Health Check, I had a pleasure to demonstrate to customers a Simple Example of Batch Mode in RowStore.
SQL SERVER – Create Index Without Locking Table
Today we will see how we can create an index without a locking table. I really feel depressed when I have to add an index to speed up my queries.
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
I was delivering training on SQL Server Performance Tuning, I received a question on nonclustered columnstore index on a temp table.
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.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
SQL SERVER – ColumnStore Indexes Without Aggregation
I suggested that the client can experiment with the columnstore indexes and it may help the performance. Comprehensive Database Performance Health Check
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.