nvogel's user avatar
nvogel's user avatar
nvogel's user avatar
nvogel
  • Member for 11 years, 8 months
  • Last seen more than a week ago
37 votes
Accepted

In SQL, is it composite or compound keys?

17 votes

When should you denormalize?

17 votes

Why is there still a varchar data type?

17 votes
Accepted

Term for a one-row table?

14 votes
Accepted

Is DB Normalization done purely based on the primary key or is it done based on all the candidate keys?

11 votes

What normal form does a surrogate key violate?

10 votes

Should you design the database before the application code is written?

10 votes

Fact table foreign keys null?

10 votes

Why should a key be made explicit?

9 votes
Accepted

Does a primary key contain exactly one Null value...?

9 votes

What is Atomic Relation in First Normal Form

8 votes

What is SQL Server Parallel Data Warehouse?

8 votes

If a table with a surrogate key has a column known to have unique non null values (eg SSN), does it violate 3NF?

7 votes

Is saving disk space still considered an advantage of normalization?

7 votes

Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

7 votes

Pros/Cons of using multiple databases vs using a single database

7 votes
Accepted

What Is The Point of a Primary Key?

7 votes

Which DBMS are fast enough for an online game (few thousand players)?

7 votes

Suggestion for Large SQL Server Database Design

6 votes

Is Oracle more demanding environment for a DBA than SQL Server?

6 votes

Can a 2NF relation be M:M?

6 votes

What can be the downside of always having a single integer column as primary key?

6 votes
Accepted

Question about choosing primary key

5 votes

Would it be considered as a bad practice to have multiple nullable FKs on a table in SQL Server

5 votes

Normalization: Is it considered compliant to split static, numeric values like a year into their own table?

5 votes

VLDB - SQL SERVER versus VFoxPro

4 votes

When to apply normalization in database design

4 votes
Accepted

Primary key should be chosen so as attributes never change?

4 votes

Explaining 2NF vs 3NF with an example

4 votes

What exactly is overlapping candidate key?