Question : During one of the last lessons at university (I’m a student), lecturer asked us to develop a database […]
Tag: identity
Grant rights to create a table with an identity column on another schema
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?
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
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?
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
Question : I frequently use MERGE statements and am quite familiar with it. Now I ran into a situation where […]
DBCC CHECKIDENT behaving inconsistently
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?
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
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)
Question : I’m working on a project that has hit a bit of a snag: I’m replacing some replication with […]