All Questions
Tagged with uniqueidentifier index
3 questions
57
votes
3
answers
53k
views
What is the optimal data type for an MD5 field?
We are designing a system that is known to be read-heavy (on the order of tens of thousands of reads per minute).
There is a table names that serves as a sort of central registry. Each row has a ...
- 765
6
votes
2
answers
2k
views
SQL Server: Create New GUID Values for Existing Index
I have an existing table with about 6 million rows. The relevant columns are:
ID int not null PK
Key uniqueidentifier not null
Read/write on this table by Key lookup is probably something like 100 ...
- 161
6
votes
3
answers
4k
views
Indexing - Uniqueidentifier Foreign Key or Intermediary mapping table?
Looking for some expert views on this guys - I'm not a DBA by trade so would appreciate any advice. Comments on the rest of the schema aren't required as it is purely fabricated to illustrate my ...
- 63