Click here to Skip to main content
Click here to Skip to main content
Search within:



Articles » Database » Database » General » Revisions
 
Comments & Discussions

INT versus GUID on a table's primary key

By , 6 May 2008
 

Revisions


  

Compare Revision Minor Date Status Editor
publicly available No 7 May '08 - 2:13 Available Smitha Vijayan

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

 Liviu Holhos
Software Developer
Romania Romania
Member
Web developer, designer and basketball enthusiast.

About Article
This article tries to show the pros and cons of using INT or GUID types on primary keys.
Type Article
Licence CPOL
First Posted 6 May 2008
Views 29,704
Bookmarked 19 times

, +
Top News

The Next Version of Android - Some of What's Coming

Get the Insider News free each morning.
Related Videos
235 Construct 2 - final thoughts on bees versus wasps
Building Websites With WordPress - 0801 Understanding Pages Versus Posts
Breaking the Law: Primary Keys in SQL Server
How to pass multiple records to a Stored Procedure
Performance Comparison - Identity() x NewId() x NewSequentialId
Database Design and Naming Conventions
Cryptographic Interoperability: Keys
A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 3
Convert SQL Server DB to SQLite DB
GUIDs as fast primary keys under multiple databases
Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
A Naming Scheme for Database Tables and Fields
Take Data Offline Using Microsoft Synchronization Services for ADO.NET
C# Multi-key Generic Dictionary
Traverse a MSSQL table without using CURSOR
A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 1
Easier Database Access with Diamond Binding (Part 2)
DBLayer Wizard V 1.0
Composable DML and Merge Statement in SQL Server 2008
Generate auto row number for a table
XTree Part III - Trees, DataSets, and DataTables
Universal Database Admin for ASP.NET and SQL Server (Reloaded)
Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 7 May 2008
Article Copyright 2008 by Liviu Holhos
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid