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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2011-12-19 : 06:47:02
|
| Hii have executed sql queryi have used multiple subquery to fetch the columns base on MAX(time) and and SUM(amount) query is taking more than 20 min to execute the query and the query have 1500 records i have creatd index and did how to reduce the time query execution mohan |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-12-19 : 07:41:21
|
| Can you post the schema for the tables including indexes, some sample data, and your query? This forum is infested with people who can look at those things and in less than 2 minutes figure out what you need to do. If you need help in posting, take a look at Brett's blog here: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-12-19 : 07:52:21
|
quote:
This forum is infested with people who can look at those things and in less than 2 minutes figure out what you need to do. If you need help in posting, take a look at Brett's blog here: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Odd choice of words... infested... what are we? Developer Roaches?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-12-19 : 07:59:09
|
| Sorry, my apologies! English is not my native language. I meant that in the nicest and most respectful way; was not meant to offend anyone. I meant to say something like "frequented by" |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-12-19 : 10:10:24
|
| I was joking. I liked your turn of phrase!Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-12-19 : 10:21:27
|
| Haha, in that case, I take back my apology and let the forum be re-infested!! :-)(Hard to tell whether someone is serious or not from plain text) |
|
|
|
|
|
|
|
|
perlformace related query