How does the Indentity property work?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » How does the Indentity property work?

How does the Indentity property work?

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Friday, November 02, 2001 12:00 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/identitylocking.asp

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1495

Kashif

Posted Monday, January 14, 2002 1:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 07, 2012 4:44 AM
Points: 1,099, Visits: 56

Hi,
Good work, b/c I have done something like storing IDENTITY values in a table in the good old days of FOXPro but Access, SQLServer and even other DBMS products support some kind of ID generation which I think is a better choice. Isn't there anything about the method SQLServer uses to get IDENTITY values?

Post #23320

Andy Warren

Posted Monday, January 14, 2002 5:31 AM

SSCertifiable

Group: Moderators
Last Login: Yesterday @ 6:51 PM
Points: 6,461, Visits: 1,377

Steve - have you tried comparing your test with one where the table doesn't have identity column? Or maybe uses unique identifier? I'd like to see those results!

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #23321

mishaluba

Posted Thursday, January 17, 2002 4:43 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:31 AM
Points: 501, Visits: 479

Hi,

I am probably missing something, but what was the result after all? Were the values spread across different sources or groupped together by the source. I don't think the article states this.

Thank you!

Michael

Post #23322

Steve Jones - SSC Editor

Posted Monday, January 21, 2002 10:05 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

This was bascially a test because I was wondering if identity was better than storing the value in a table and manually updating it with each insert. It was a kind of benchmark to see how SQL handles the identity.

I would like to update this to use uniqueidentifer and run some timing benchmarks.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23323

neiljacobson

Posted Monday, January 21, 2002 4:03 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, March 21, 2012 5:01 PM
Points: 69, Visits: 21

Under most circumstances I agree that an Identity column is a simple method for numbering rows.

On occasions where an insert is needed with the "Set Identity_Insert ON" function be aware that: [Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner] from BOL.

i.e. a user may not be able to perform a bulk insert unless they have these permissions.

Post #23324

Steve Jones - SSC Editor

Posted Monday, January 21, 2002 4:55 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

that is true. haven't run into it, but worth noting.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23325

Steve Jones - SSC Editor

Posted Monday, January 21, 2002 4:58 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

that is true. haven't run into it, but worth noting.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23326

« Prev Topic | Next Topic »

Permissions