The uniqueidentifier tag has no wiki summary.
4
votes
2answers
177 views
Securely generate a UNIQUEIDENTIFIER in SQL Server
I intend to be using a UNIQUEIDENTIFIER as an access key that users can use to access certain data. The key will act as a password in that sense.
I need to generate multiple such identifiers as part ...
12
votes
5answers
376 views
Sequential GUID or bigint for 'huge' database table PK
I know this type of question comes up a lot, but I've yet to read any compelling arguments to help me make this decision. Please bear with me!
I have a huge database - it grows by about 10,000,000 ...
0
votes
1answer
29 views
Mysql database connector table or keys
This may be a simple a question but I just wanted to clarify, at work I have a table containing a list of titles and I also have a list of authors in two different tables.
What would be best way to ...
3
votes
2answers
3k views
How to use Unique key via combinations of table fields?
Take a look at the following sqlfiddle: http://sqlfiddle.com/#!2/dacb5/1
CREATE TABLE contacts
(
id int auto_increment primary key,
name varchar(20),
network_id int,
...
8
votes
4answers
249 views
Is this a standard way to design a database?
I recently learned about how relationships are defined in the database at work, and was wondering if this is a standard practice.
Let's say we have two processes: Process A, and Process B. Process B ...
0
votes
1answer
36 views
Should I record ID numbers in a table where I record who look whom profile page
This is how I have designed:
visitorID
visitedprofileID
datetime
Is it a good idea to add an ID (primary key) to the table, I mean recordID (primary key).
(MySQL with PHP)
5
votes
3answers
533 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 ...
2
votes
1answer
201 views
Shortest Query to Combine Count and Unique (Oracle)
I have the following query which works for me:
select count(*)
from (
select UNIQUE col1, col2, col3
from my_table
where cond1 = 'A'
and cond2 = 'B'
and cond3 = 'C'
)
Is it possible ...
3
votes
3answers
125 views
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted?
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted? For instance, I'm splitting payments and charges to their own tables from a previously unified ...
6
votes
4answers
391 views
Purpose of IDs in a User Table Database
In a table, such as a user table, where there will only be 1 row with a for any particular user, why have an ID field, let alone as the primary key?
32
votes
3answers
5k views
Guid vs INT - Which is better as a primary key?
I've being reading around reasons to use or not Guid and int.
int is smaller, faster, easy to remember, keeps a chronological sequence. And as for Guid, the only advantage I found is that it is ...
