2023-07-31
505 reads
2023-07-31
505 reads
2023-07-19
412 reads
There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.
2020-05-21
8,261 reads
2024-12-23 (first published: 2020-05-05)
725 reads
2020-03-06
697 reads
2020-02-27
717 reads
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
2019-05-03
2019-02-26
1,133 reads
2019-02-21
806 reads
2019-02-14
772 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers