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 |
|
SantanaSQL
Starting Member
6 Posts |
 Posted - 2012-03-13 : 10:48:21
|
| Hi AllI have 11 tables to deal with, these tables have relations, Primary Keys and Foriegn Keys. the architeched of the application that uses the SQL allowed to visit the SQL server only once, to minimize the trips back and forth to the server. What would be the best approach, shall I load 11 tables in memory sapartly or create a View and then call that view, less tables to work with, Or Stored Procedure that calls all the tables all put them all in momery.Not sure what would be the best approach, We would be retreiving information from these tables only. There will not be update or Altering to the tables.Any advice is well appreciated.thanksSantana |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-13 : 15:26:17
|
| why not write procedure which joins all tables on related fields and get required data as a single resultset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
11 tables Advice