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 18 hours ago
stats profile views 73

36 Answers

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