SQL Server 2005 Database Question: Enterprise Database built for Maximum performance and high scalability!
This question has three parts
#1 - Performance: Will performance increase if I choose to use NewSquentialID() instead of NewID() for replication ROWGUID? or this does not matter for replication, better to have the number random as possible?
#2 - Performance: Should the primary key "bigint" and "int" and "Rowguid" be removed and all replaced with a single "uniqueidentifier" Primary key, with the default set to NewSquentialID()?
#3 Optimisation: Is there anything else I can do to optimise the database below? (I have ROWGUID in every single table).
See Sample ER Diagram below, currently:
PRIMARY KEY has been set to identity, not unique
ROWGUID has been set to default: Newid(),unique.