http://www.sqlservercentral.com/Content tagged T-SQL, Data Types, Database Design posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?http://www.sqlservercentral.com/redirect/articles/64666/2008/10/23http://www.sqlservercentral.com/redirect/articles/64666/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/