Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
What is going on with their server as I had no access to their data or schema. Let us learn about how identity and constraint confusion created problems.
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No.
You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.
I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
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.