I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.
SQL SERVER – Listing All Memory Optimized Files with Logical Name and Physical Name
Recently I had to work with a client for whom I have to build a script for Listing All Memory Optimized Files with Logical Name and Physical Name.
SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism
One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
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
Why Attend 21 Essential Scripts: Performance Tuning for Everyone?
It has been the entire year since I am doing various road tour with my training – 21 Essential Scripts: Performance Tuning for everyone.
SQL SERVER – Table Variable or Temp Table – Performance Comparison – INSERT
In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Comprehensive Database Performance Health Check
SQL SERVER – Regular Table or Temp Table – TempDB Logging Explained
After the blog posts about temp and regular table, I have received questions about it hence I am writing this blog post about TempDB Logging.