Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag IDENTITY Property Rss

Search for any content tagged identity property

   Items 1 to 13 of 13   
 

Use of Identity Property to Resolve Concurrency Issues

This article describes how the identity property was used to resolve contention in a database  Read more...
By Ajit Ananthram 2013/03/22 (first published: 2011/02/24) | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 17,714 reads

Tip: Resetting Identity Fields

How to reset an identity field to the next contiguous value, after deletions.  Read more...
By Banyardi Schmardi 2012/12/03 | Source: SQLServerCentral.com | Category: dbcc checkident
Rating: |  Discuss |   Briefcase | 8,377 reads

The Sequence Object in SQL Server 2012

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.  Read more...
By Sanil Mhatre 2012/06/04 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 7,835 reads

Obtaining Identity Column Values in SQL Server

When you enter a new record into a table that contains an identity column, the identity value will be set with the next available value. Your database design often requires you to obtain that value, so you need to be able to find it.  Read more...
By Additional Articles 2011/05/05 | Source: Database Journal | Category: identity property
Rating:  Rate this |   Briefcase | 4,913 reads

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

This article demonstrates how to prevent primary key violation issues in transactional replication.  Read more...
By Additional Articles 2011/04/13 | Source: SQL Server Performance | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,077 reads

Use of Identity Property to Resolve Concurrency Issues

This article describes how the identity property was used to resolve contention in a database  Read more...
By Ajit Ananthram 2013/03/22 (first published: 2011/02/24) | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 17,714 reads

Identity Property Range Checking in SQL Server

This article examines practical methods of managing and monitoring large tables which make use of the IDENTITY property.  Read more...
By Additional Articles 2011/01/04 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 3,650 reads

Return to Sender: Identity Values and Triggers

By quickly and easily obtaining the identity value, the OUTPUT clause of an INSERT statement can obtain the auto-generated identity value of a row, and so will allow the application to immediately reference the new row or add rows to another table that use the identity value as a foreign key reference.   Read more...
By Additional Articles 2010/11/09 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,096 reads

Efficiently Reuse Gaps in an Identity Column

This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.  Read more...
By Additional Articles 2010/03/03 | Source: SQLTeam.com | Category: identity property
Rating: (not yet rated)  Rate this |   Briefcase | 2,736 reads

Overusing Identities

Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.  Read more...
By Steve Jones 2010/03/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 292 reads

Retrieving Identities on set-based inserts

Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.  Read more...
By Steve McRoberts 2010/01/20 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 4,088 reads

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,927 reads

RESEED in SQL 2000 and SQL 2005/2008

This article looks at the difference in behavior of RESEED in SQL Server 2000 and SQL Server 2005/2008  Read more...
By Raghuram (AJ) 2008/05/20 | Source: SQLServerCentral.com | Category: reseed
Rating: |  Discuss |   Briefcase | 3,819 reads
   Items 1 to 13 of 13