SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How much do encrypted GUIDs
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 05/08/2013 :  10:01:54  Show Profile  Reply with Quote

affect systems? More RAM & disk? I see PK, FK and more foreign keys in each table (de-normalisation?)

How about a fact table for all GUIDs, and all other dim / ref tables just use that to join, and other indexes are smallints?

How much does encryption should be necessary? How would a datacenter database be prone to risk, if all FKs were just smallints?

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1673 Posts

Posted - 05/09/2013 :  16:14:22  Show Profile  Reply with Quote
The use of smallints is limited by the number of entries in your data. If you have more than 64K entries, smallints are a non-starter. Since you mentioned that you are in a "datacenter", I suspect that your tables are larger than this. It sounds like, though you have not said so explicitly, that your current schema uses GUIDs as unique (primary?) keys and they are used as the basis for foreign keys. A case can be made that using GUIDs in this way is less than ideal. They are wider than an int or smallint which would impact their use in indexes. How many entries do you have in your tables?

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000