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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2010-03-01 : 10:09:56
|
| I'm 1 of 3 C#/ASP.NET programmers at my small company who have all only been programming for a couple years. There is no DBA so we have to play that role ourselves. To retrieve specific data for our front-end, what we're doing is using a series of views to parse down the data specific to what we need. The complexity of the views and tables in addition to the size of the data results in very slow queries. So I believe we need to convert these views and tables into a more efficient means of data access. I think we either need to use stored procedures or function tables. Which one of these should we be using? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 10:28:07
|
| i think you can use stored procedures. Any of common code that you need to use across can be put in functions and called within your procedures------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Most efficient way to get database results