Stack Exchange

sqlvogel

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
19
In SQL, is it composite or compound keys?
dba.stackexchange.com

16
What deficiencies do you feel exist with SQL and what changes would you make to it?
stackoverflow.com

15
Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)
stackoverflow.com

14
Would like to Understand 6NF with an Example
stackoverflow.com

12
Is DB Normalization done purely based on the primary key or is it done based on all the candidate keys?
dba.stackexchange.com

12
Term for a one-row table?
dba.stackexchange.com

11
Union All With if/else T-SQL
stackoverflow.com

9
Why is there still a varchar data type?
dba.stackexchange.com

8
Fact table foreign keys null?
dba.stackexchange.com

8
Are primary keys passé?
stackoverflow.com

7
When should you denormalize?
dba.stackexchange.com

7
Should you design the database before the application code is written?
dba.stackexchange.com

7
functional dependencies in SQL databases Normal forms
stackoverflow.com

7
Why can't I perform an aggregate function on an expression containing an aggregate but I can do so by creating a new select statement around it?
stackoverflow.com

7
Problems in coordination between software and database teams
programmers.stackexchange.com

6
Which DBMS are fast enough for an online game (few thousand players)?
dba.stackexchange.com

6
can we have a foreign key which is not a primary key in any other table?
stackoverflow.com

6
Can I select 0 columns in SQL Server?
stackoverflow.com

6
Difference between a row-oriented and column-oriented databases in dealing information retrieval
stackoverflow.com

6
What is best practice for representing time intervals in a data warehouse?
stackoverflow.com

6
Convert Mdb to Sql Server
stackoverflow.com

6
Why are composite primary keys still around?
stackoverflow.com

6
Why we can't have more than one primary key?
stackoverflow.com

6
Does creating a foreign key automatically mean referential integrity?
stackoverflow.com

6
May a 6NF Table contain a foreign key?
stackoverflow.com

5
Suggestion for Large SQL Server Database Design
dba.stackexchange.com

5
Is Oracle more demanding environment for a DBA than SQL Server?
dba.stackexchange.com

5
What Is The Point of a Primary Key?
dba.stackexchange.com

5
(Database Design) why in the database tables most of the times primery key name is: <tablename_id> and not <id>?
stackoverflow.com

5
Does the order of columns matter in a group by clause?
stackoverflow.com

1 2