Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.
SQL SERVER – Find Missing Identity Values
I recently received a question during Comprehensive Database Performance Health Check about how to Find Missing Identity Values.
SQL SERVER – Identity Column is Difficult to Remove
The IDENTITY property is difficult to remove through a column alteration because SQL Server doesn’t support that operation. Existing values need protection.
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.