Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.
I discuss this during Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.
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.