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.
SQL SERVER – Parallelism for Heap Scan
Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the  Comprehensive Database Performance Health Check engagement about Parallelism for Heap Scan.
SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience
It was my pleasure and honor that I was invited to the Brent Ozar Unlimited Office Hours. During the office hours, we received quite a few interesting questions, some were very complicated and some were super fun. However, the best part of attending the office hours was the company. I was fortunate to have Brent, Richie, and Tara along with me in this office hours. Please note that the questions which we discussed during the session were asked live.
SQL SERVER – What is Forwarded Records and How to Fix Them?
During the early year of my career, one of the most popular questions I used to receive was – What is Forwarded Record? I used to find this question very valid as many people yet did not know what is the forwarded record. In most of the cases as time passes by more knowledge is spread amount SQL Server users and the number of questions reduces on a single topic. However, this is something I can’t say is true for Forwarded Records.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server?