I discuss this during Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.
How to Add Constraint With No Validation? – Interview Question of the Week #299
Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
SQL SERVER – Identity and Constraint Confusion
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.
Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
SQL SERVER – Having Two Identity Columns for A Single Table
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.
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.