The first key column as uniqueidentifier datatype. In this blog post, we will discuss Using NEWID vs NEWSEQUENTIALID for Performance.
SQL SERVER – Identifying Query Generating Malicious Wait Type
In this blog post, we will learn about how to fix the performance issue with the malicious Wait Type. Comprehensive Database Performance Health Check
SQL SERVER – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards
While working together we figured out one of the many issues was the priority boost server configuration. Let us talk about it a bit more in detail.
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 – Modifying Table Used In SCHEMABINDING View
I received a very interesting question from the user. The question is about modifying the table used in the SCHEMABINDING View.
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
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.