One of the questions I had received from a client was about how to find out fragmentation in columnstore index. Let us discuss it today.
we had an interesting situation where we wanted to Find the Count of Table Used in Query From Cache. Let us see how we can do that in today’s blog post.
One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.