After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.
SQL SERVER – Resources for DevAroundTheSun Session
Dev Around The Sun is a technology event with tech talks and human skills talks. In this blog post, we will see important resources for DevAroundTheSun.
SQL SERVER – Visible Offline Scheduler and Performance
Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance.Â
SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention Changing Primary Key to Non-Clustered
You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.
SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access
I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.
Foundations of Document Databases with MongoDB – Video Course
I have recently build a Video Course at Foundations of Document Databases with MongoDB focusing on helping users to get started with MongoDB.
Stress Testing with oStress – SQL in Sixty Seconds #087
One of the things which we cover in my  Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention with OPTIMIZE_FOR_SEQUENTIAL_KEY
I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.