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 37    Older >>
 

What will be Identity value

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

Reset of Identity

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

Identity Insert

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

Identity Columns

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

What will the max id be?

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

Changing Identity Columns

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

T-SQL

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

IDENTITY INSERT

By Lokesh Vij 2012/09/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,600 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,825 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,826 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 | 563 reads

Inserted Identity

By Chris Fradenburg 2011/08/26 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,708 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,891 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,067 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 | 888 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,700 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,633 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,078 reads
   Items 1 to 20 of 37    Older >>
 
Tags
t-sql (22)    
truncate table (3)    
database design (2)    
replication (2)    
reseed (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)    
identity_insert (1)    
int (1)    
locking (1)    
maintenance and management (1)    
max (1)    
miscellaneous (1)    
output (1)    
primary key (pk) (1)    
sequence (1)    
sloss (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2012 (1)    
transactions (1)