sqlvogel

less info
meta site favicon meta user | stack exchange network profile network profile
1,630 reputation
612
bio website
location
age
visits member for 2 years, 1 month
seen 20 hours ago
stats profile views 71

36 Answers

newest activity votes
19
In SQL, is it composite or compound keys?
12
Term for a one-row table?
12
Is DB Normalization done purely based on the primary key or is it done based on all the candidate keys?
9
Why is there still a varchar data type?
8
Fact table foreign keys null?
7
Should you design the database before the application code is written?
7
When should you denormalize?
6
Which DBMS are fast enough for an online game (few thousand players)?
5
What Is The Point of a Primary Key?
5
Is Oracle more demanding environment for a DBA than SQL Server?
5
Suggestion for Large SQL Server Database Design
4
What is SQL Server Parallel Data Warehouse?
4
Can a 2NF relation be M:M?
4
VLDB - SQL SERVER versus VFoxPro
4
Normalization: Is it considered compliant to split static, numeric values like a year into their own table?
3
Primary key should be chosen so as attributes never change?
3
Would it be considered as a bad practice to have multiple nullable FKs on a table in SQL Server
3
Purpose of IDs in a User Table Database
3
When to apply normalization in database design
3
What is Atomic Relation in First Normal Form
2
What normal form does a surrogate key violate?
2
What computations can NOT be performed in standard SQL?
2
Is normalization process needed?
2
What are the alternatives for an ORDER BY clause in a View?
2
Pros/Cons Using multiple databases vs using single database
2
What are the top 5 design decisions which need to be made when implementing a database?
2
What is wrong in debunking myths about clustered indexes?
1
Database design - People and Organisations
1
why doesn't time for a simple update scale linearly with the number of records?
1
What are the performance considerations between using a broad PK vs a separate synthetic key and UQ?
1 2