Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.
SQL SERVER – Scan Count Zero for Statistics IO
On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.
Nonclustered Primary Key – SQL in Sixty Seconds #119
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.Â
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.
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.