Primary Keys: IDs versus GUIDs. Using INTs or GUIDS as the primary key. Jeff likes GUIDs. Go through the comments and find Rami because he (she?) has it right – if you have any kind of size to your database you are going to take a major hit on performance just getting data on and off the disk. While there’s just a smidge of room to waffle on this in transactional systems, the answer is a resounding NO to GUIDs as PKs for data warehouses/marts.
