Need to tune quries to improve performance

Check this bunch

Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]

That you have embedded your queries into StoredProcedures is a very good step because SQL Server will make some execution plans to run them.

Your queries seem to be at their most optimized state (read here in-vs-join-vs-exists/[^]) so try to work on application side. If you are working with millions of record do not try to show all of them to user try to group them in alphabetic manner or some other grouping criteria that you know better.

Adding a where clause and confining the result set should improve your application performance.

Also consider using some UI controls that support lazy loading.

Hope It Helps.

Looks like you're fetching the data in parts and storing intermediate results somewhere. Instead try using joins: http://msdn.microsoft.com/en-us/library/ms191517.aspx[^]

DFor example something like:

select * from a

select * 
from a, b, c
where b.aid = a.id 
and   c.bid = b.id

And as said in previous posts, fetch only what you need, not everything (*).

Hi....

Step 1 : Remove "*" and Add Column Name List in Select Statement.

Step 2 : Use JOINS (Don't Use Sub Query)

SELECT Column_List
FROM a
INNER JOIN b ON a.id=b.id
INNER JOIN c ON c.id=a.id

This will helps u....

Hi,

below query will server the same thing,

select a.* from a,b,c where a.id = b.aid and c.bid = b.Id

if it is not giving the same answer please let me know, as i do not have all tables to test this query.

thanks,
-amit.