A SharePoint check-in failed with Msg 8115, Arithmetic Overflow Error converting IDENTITY to data type INT. How I found the table with Profiler and fixed it.
SQL SERVER – Jump in Identity Column After Restart
A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.
Interview Question of the Week #030 – Retrieve Last Inserted Identity of Record
Retrieve the last inserted identity of record safely, compare identity functions with a trigger, and capture multi-row values using OUTPUT.
SQL SERVER – Finding Out Identity Column Without Using Column Name
Did you know SELECT $identity finds the identity column without using column name? Here is how it works, and how to check if a table has one.
The Last Entered Row: Why a Table Needs an Ordering Column
A table has no last row until you define one. Here is how identity, event time and ties give different answers.
SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table
Can you add an auto incremental identity column to a table after it is created? The answer is both no and yes, and I show the ALTER TABLE script.
SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR
A reader noticed that a failed insert still bumps the identity value. I show how to reset the identity seed after a ROLLBACK or an error.