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

Content with tag IDENTITY Property Rss

   Items 1 to 20 of 38    Older >>
 

Identify Missing Sequence/Identity Numbers

This script is used to identify the missing sequence numbers or identity numbers.  Read more...
By Vignesh Arulmani 2014/11/20 | Source: SQLServerCentral.com | Category: missing numbers
Rating: |  Discuss |   Briefcase | 807 reads

What will be Identity value

By Mitesh Oswal 2014/03/25 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,098 reads

Reset of Identity

By Vivek Raj 2013/07/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,067 reads

Identity Insert

By Ashok Berwal 2013/05/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,167 reads

Identity Columns

By Bilal Mahmood 2013/04/10 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,096 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,723 reads

What will the max id be?

By Ben Kubicek 2012/12/19 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,173 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,390 reads

Changing Identity Columns

By Kenneth Fisher 2012/10/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,243 reads

T-SQL

By Sagari Bellamkonda 2012/10/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,698 reads

IDENTITY INSERT

By Lokesh Vij 2012/09/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,627 reads

Generate insert statements with column names for any or all tables

Generate a script of insert statements with column names for any table including those with identity columns.  Read more...
By Darren Gordon 2012/06/15 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 2,890 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,856 reads

Expanding identity to negative values

Identity integer can be max 2mld, if the table has many rows I can expand the identity.  Read more...
By Federico Iori 2012/02/10 | Source: SQLServerCentral.com | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 566 reads

Inserted Identity

By Chris Fradenburg 2011/08/26 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,727 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,941 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,093 reads

proc to change PK

This script was created for a client who had uniqueidentifier PKs, but wanted to switch to BIGINT IDENTITY PK for better db performance.  Read more...
By colin_sloss 2011/03/24 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: (not yet rated) |  Discuss |   Briefcase | 891 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,723 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,668 reads
   Items 1 to 20 of 38    Older >>
 
Tags
t-sql (22)    
truncate table (3)    
database design (2)    
replication (2)    
reseed (2)    
sequence (2)    
uniqueidentifier (2)    
checkident (1)    
data modeling (1)    
data types (1)    
dbcc (1)    
dbcc checkident (1)    
delete (1)    
drop primary key (1)    
editorial (1)    
expanding (1)    
gaps between numbers (1)    
identity_insert (1)    
int (1)    
locking (1)    
maintenance and management (1)    
max (1)    
miscellaneous (1)    
missing numbers (1)    
output (1)    
primary key (pk) (1)    
sloss (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2012 (1)    
transactions (1)