SQLServerCentral: Content tagged IDENTITY

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

Rating: (not yet rated) |

Discuss |

Briefcase | 254 reads

Inserted Identity

By Chris Fradenburg 2011/08/26 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 2,490 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

Rating:

Rate this |

Briefcase | 4,590 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 | 1,825 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 | 823 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 2011/02/24 | Source: SQLServerCentral.com | Category: locking

Rating:

|

Discuss |

Briefcase | 11,945 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,367 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 | 2,892 reads

Fun with IDENTITY - Part II

By Nakul Vachhrajani 2010/10/06 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 3,091 reads

Fun with IDENTITY - Part I

By Nakul Vachhrajani 2010/09/29 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 2,984 reads

What will be the output of the following?

By SQL Buzz 2010/06/28 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 3,332 reads

What identity comes next?

By Ron Carpenter 2010/05/31 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 3,387 reads

Using IDENTITY as a key column

By Hugo Kornelis 2010/04/20 | Category: identity

Rating: (not yet rated) |

Discuss |

Briefcase | 4,338 reads

Script to check current identity of Tables

Used to check all current identities on all user tables Read more...

By Sean Kotze 2010/03/17 | Source: SQLServerCentral.com | Category: identity

Rating:

|

Discuss |

Briefcase | 1,284 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

Rating: (not yet rated) Rate this |

Briefcase | 2,512 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 | 265 reads