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 |
|
Hobgoblin
Starting Member
3 Posts |
 Posted - 2010-04-15 : 06:53:50
|
| I'm not sure that this is the write place for this question, but I'm sure that I'll get some answers.I'm using sql server 2005 and I need to optimize some query. How to do that? I was using Toad for Oracle and in it was optimization part with query costs etc... How to do that using sql 2005? Is it possible?Thanks |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-15 : 07:03:26
|
| Gail Shaw's got a good set of articles covering everything you want to know:http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-15 : 07:33:31
|
"I was using Toad for Oracle and in it was optimization part with query costs "Similar available in SSMS and/or you can put explicit statements in your code to get the same info output as a Result Set - depends whether you prefer to see it all graphically with hover-over-style detailed info, or the detailed info included and all output as text. Being old I prefer the old-fangled second of those two  |
|
|
|
Hobgoblin
Starting Member
3 Posts |
Posted - 2010-04-16 : 02:20:06
|
| Thank you for your answers. I think that would be useful ;) |
|
|
|
|
|
|
Query optimization