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

Identity Column Datatype

By Sasidhar Pulivarthi 2015/03/09 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 1,835 reads

The Identity Limit

By Steve Jones 2015/01/20 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,097 reads

Identity Data Types

By Steve Jones 2015/01/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,229 reads

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 | 991 reads

Update Identity column

By Igor Micev 2014/11/17 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 1,943 reads

A Deeply Planted Seed

By Andy Warren 2014/07/01 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 1,850 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.  Read more...
By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 6,319 reads

What will be Identity value

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

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.   Read more...
Rating: |  Discuss |   Briefcase | 1,246 reads

IDENTITY

By Igor Micev 2014/02/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,575 reads

IDENTITY RESEED

By Lokesh Vij 2014/01/24 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 2,391 reads

Compare Current IDENTITY Value to DataType's Boundary

This script finds all tables which contain IDENTITY property, and compares the current seed to the maximal boundary of the data type.  Read more...
By Arthur Gimpel 2013/11/18 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 548 reads

Reset of Identity

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

Identity Insert

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

FK to IDENTITY

By Nenad Zivkovic 2013/04/24 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,004 reads

Identity Columns

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

What will the max id be?

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

Changing Identity Columns

By Kenneth Fisher 2012/10/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,256 reads
   Items 1 to 20 of 49    Older >>
 
Tags
t-sql (29)    
truncate table (3)    
database design (2)    
datatypes (2)    
replication (2)    
reseed (2)    
sequence (2)    
uniqueidentifier (2)    
checkident (1)    
cursors (1)    
data modeling (1)    
dbcc (1)    
dbcc checkident (1)    
delete (1)    
deleted (1)    
drop primary key (1)    
editorial (1)    
expanding (1)    
foreign keys (fk) (1)    
gaps between numbers (1)    
ident_current (1)    
identity_insert (1)    
inserted (1)    
int (1)    
integration services (ssis) (1)    
locking (1)    
maintenance and management (1)    
max (1)    
merge (1)    
miscellaneous (1)    
missing numbers (1)    
output (1)    
performance (1)    
primary key (pk) (1)    
scope_identity (1)    
sequence numbers (1)    
sloss (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server 2014 (1)    
transactions (1)