Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: identity

Identity column re-seed: when it is necessary?

By adminPosted on February 1, 2023

Question : During one of the last lessons at university (I’m a student), lecturer asked us to develop a database […]

Grant rights to create a table with an identity column on another schema

By adminPosted on January 22, 2023

Question : I have a user in charge of deploying DDL on other schemas than its own. This user can […]

Does Clustered Index on GUID create more fragmentation than Non Clustered Index?

By adminPosted on January 21, 2023

Question : I have a simple table: CREATE TABLE [dbo].[UserTestGroups]( [UserTestGroupId] [int] IDENTITY(1,1) NOT NULL, [Token] [nvarchar](100) NOT NULL, [TestId] […]

Populate Identity column with sequential numbers restarting count on change of key field

By adminPosted on January 12, 2023

Question : I am attempting to populate an Identity column with sequential numbers but I want the count to start […]

How is SQL Server host identity ensured?

By adminPosted on January 8, 2023

Question : When I connect to some e-commerce website with my browser I use HTTPS that uses a certificate that […]

MERGE with IDENTITY_INSERT ON does not work if Identity is not the primary key

By adminPosted on January 1, 2023

Question : I frequently use MERGE statements and am quite familiar with it. Now I ran into a situation where […]

DBCC CHECKIDENT behaving inconsistently

By adminPosted on December 13, 2022

Question : I have a script that sometimes needs to be run on a fresh database that’s just had all […]

Where does SQL Server physically store the IDENTITY VALUE for a table?

By adminPosted on November 15, 2022

Question : I’m hoping someone can point me in the right direction on this one. Here’s my workings out so […]

SQL 2012 insert data into a table from another table and custom columns

By adminPosted on November 8, 2022

Question : I’m trying to insert data from one table into another table and I also have 4 columns that […]

What locking can I expect with DBCC CHECKIDENT(RESEED)

By adminPosted on November 5, 2022

Question : I’m working on a project that has hit a bit of a snag: I’m replacing some replication with […]

  • 1
  • 2
  • 3
  • …
  • 9

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding