Question : The most important table of my database is about 300,000 records, and growing. More than 20 tables have […]
Tag: identity
Identity Column Behaviour After Replication
Question : Say we have two Servers: Server A and Server B. Data is being replicated (vanilla Transactional Replication) from […]
Create a “INTO” table with primary key
Question : Maybe for this community my problem is easy, but for me (a simple Java programmer) it’s a BIG […]
Stored Procedure – Reseed Identity
Question : I have a bunch of LU tables that have values added and deleted all the time. Therefore, I […]
Primary keys due to inheritance
Question : I am trying to design a database for postgrad office and we have a parent class “User” that […]
Existing data to new table, how to set up the PK & Identity
Question : I am moving an Access app to SQL Server. I have confirmed the data in the existing PK […]
Identity value jumps when restarting SQL Server
Question : We just switched from SQL Server 2008 R2 to SQL Server 2012. I am facing a problem with […]
Copy SQL table to other server identity becomes int
Question : I just built an Umbraco website. This uses a not-that-small SQL Server db. I copied this DB using […]
How to add a PostgreSQL 10 identity column to an existing table with rows?
Question : I have a table with some rows and I try adding an identity column using the command: ALTER […]
How to reduce identity values to avoid integer overflow?
Question : I have some leaf tables (no FK towards them) with a few hundreds of thousands records that are […]