Blog

Archive:

Search site:

Tags:

Compilation (1) Concurrency (3) docker (2) Execution Plans (6) Identity (1) Indexes (2) internals (11) linux (4) Optimization (6) Parameterization (1) Performance (9) Performance Tuning (2) postgres (6) RCSI (2) sql (1) SQL Server (24) Statistics (2) Stored Procedures (1) Transactions (1) Version Store (2)

Categories:

Docker (2) Linux (4) PostgreSQL (6) SQL Server (24)

Tag: Identity

  • Reseed Identity – Can it Cause Clashes?

    Reseed Identity – Can it Cause Clashes?

    I recently had cause to reseed an identity column on a table in SQL Server, which got me wondering “If we reseed an identity column to a value lower than the existing identity values in the column, could it cause a clash?” Because why wouldn’t you wonder if you can cause something to break, whilst…

    Keep reading