Home Forums SQL Server 2008 SQL Server 2008 - General UNIQUEIDENTIFIER vs BIGINT RE: UNIQUEIDENTIFIER vs BIGINT

  • October 2, 2012 at 9:35 am

    #1544455

    Eugene Elutin (10/2/2012)

    It depends, but in this case, most likely your PK should be clustered and you will create non-clustered index on CustomerCode.

    That's what I already do, on every table have an Id column BIGINT IDENTITY and the PK on that column is clustered so the data write is sequential.

    GUID have the NEWSEQUENTIALID() but I've read people having problems with that (not working properly) and performance issues.

    http://www.codeproject.com/Articles/32597/Performance-Comparison-Identity-x-NewId-x-NewSeque.

    So I'll stick with what I'm doing 🙂

    Thanks,

    Pedro


    If you need to work better, try working less...