Earlier I wrote two blog post on the topic of COUNT(*) and Index and today I have to build a video on that topic as many of you really wanted.
I discuss this during Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.
Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.
Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
If know the answer, I like to answer them. Today we are going to discuss Unlocking User Without Changing Password. Let us learn.