I had a very interesting conversation with their Senior DBA about ColumnStore Index Displaying Actual Number of Rows To Zero.
SQL SERVER – Batch Mode in RowStore – Performance Comparison
Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.
Finding Regressed Queries in Query Store After a Deployment
Find regressed queries in Query Store using weighted before-and-after duration and CPU, then compare plans and changed procedure text.
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 – 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 – Find the Growth Size for All files in All Databases – Part 2
A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. Today, we will post a small correction to it.
Missing Index Suggestions: Three Checks Before You Create One
Review missing index suggestions against existing indexes, key order, and INCLUDE size before adding extra write overhead.