which is better for performance GUID or sequence

thanks

This is the nearest solutions i may use, using the following article.

http://sqlperformance.com/2013/09/t-sql-queries/random-collisions

my scenario,

More 1000000 users registers with site and uploads documents minimum 10. Even though i can use...

let us assume i am going to store documents.

for every document i am going to set a primary key that will be an alphanumeric value (may be 4 digits)

n users...

Lowell (2/11/2015)

---

carrieathomer (2/11/2015)

---

for a new project

i need to create random alphanumeric characters as primary key values when inserting a record.

eg: cmSbXsFE3l8

it can start from 4 digit characters and can grow...

Thanks all for the discussing the issue

Matt Miller (#4) (6/27/2014)

---

A tally table - whether a physical one or one that you would build on the fly using ROW_NUMBER() - can churn through 1M records in under...

no cache is to create continuous values even when there is a server restart.

while loop is to make successfull insertion when there is a failure

i tried to insert 1 million rows in a test table using sequence and using the code snippet which i posted first. Surprisingly, the query with with select max created...

Sean Lange (6/26/2014)

---

carrieathomer (6/26/2014)

---

do you see the url of this page, the id used inthe URL.

jumping 10000 everytime for server restart (happens in shared hosting environment) creates 7 digit or...

do you see the url of this page, the id used inthe URL.

jumping 10000 everytime for server restart (happens in shared hosting environment) creates 7 digit or 8 digit id...

i want continuous primary key integers without jump in values.

the while works until a successful insertion of a new record with unique primary key value

that is reason using while statement and even if there is failure it is going to try again.

Occassional delete is ok,

so it will be 101

The idea is how to create the values incrementally.