Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2010-04-23 : 11:14:49
|
| I have a db (course material, gradebook, assignments, quizzes, discussion forum)Is it better to have the discussion forum in one table and create a noncluster index on sectionid where sectionid is a course offered to a group of students) or create separate tables for each section programatically.Concerning the quizzes is it better to have the tables in the same database of course the quizzes are linked to student table and section tableis it possible have you ever heard about linking tables in two different databasessarah |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-23 : 11:41:46
|
quote:
Is it better to have the discussion forum in one table and create a noncluster index on sectionid where sectionid is a course offered to a group of students) or create separate tables for each section programatically.
One table. If you make tables for sections then whenever you add a new section you'd have to add a new table -- also you'd probably have to use dynamic sql to reference them. Better to have a column as you illustrate quote:
Concerning the quizzes is it better to have the tables in the same database of course the quizzes are linked to student table and section table. is it possible have you ever heard about linking tables in two different databases
Not sure I follow you completely. You *Can* reference tables between databases on the same server with part notation. <database>.<schema>.<table>You *can* even reference other severs in 4 part notation <servername>.<database>.<schema>.<table> but that's quite rare.I'd go with the same database if that makes business sense.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
DB Structure for best performance