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
ur 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.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
Question: What is Trusted Constraint in SQL Server?
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to Create Primary Key Without ANY Index?
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns customers today.