SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Multiple Tables Views
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SantanaSQL
Starting Member

6 Posts

Posted - 03/13/2012 :  12:10:39  Show Profile  Reply with Quote
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

USA
35932 Posts

Posted - 03/13/2012 :  13:08:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 03/13/2012 :  13:56:19  Show Profile  Reply with Quote
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

USA
35932 Posts

Posted - 03/13/2012 :  14:01:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Pakistan
1 Posts

Posted - 12/02/2012 :  14:58:44  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000