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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Multiple Tables Views

Author  Topic 

SantanaSQL
Starting Member

6 Posts

Posted - 2012-03-13 : 12:10:39
Hi All

I 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.
thanks
Santana

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-13 : 13:08:27
Just how big are these tables and how much memory does the application server have? And why oh why is it being architected this way?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SantanaSQL
Starting Member

6 Posts

Posted - 2012-03-13 : 13:56:19
The Tables are small, the biggest table about 50 rows. The client requested The architect to be done that way where we design our code to have one trip to the SQL server and load everything in memory and work with tables from Memory.

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-13 : 14:01:01
Your client doesn't have programming or database experience, it sounds like at least.

Just do a select * for each table you need and put that into memory on the app server. You don't need to use views or anything really. And yes separately is fine. You can't use one view for this as that would be one gigantic result set and probably isn't right.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Asif Noor
Starting Member

1 Post

Posted - 2012-12-02 : 14:58:44
hi
iam new developer please tell me the syntax of stored procedure in sql 2005 and how to work in it

qalandar
Go to Top of Page
   

- Advertisement -