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 |
|
kallushashi
Starting Member
11 Posts |
 Posted - 2011-10-20 : 11:40:16
|
| Hi Every one iam facing a problem in 2008 thats performance well i i have created a table with 200000 rows in it well in 2008 server its taking almost 20min where else same query its taking not even 2minutes in 2005 so i want to know why the performance got decresed in 2008 where the configuration and network wise its all ok but still same problem can u guyz give me the solution.shashi |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-21 : 06:13:27
|
| Look at the query plans and see what's different.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kallushashi
Starting Member
11 Posts |
Posted - 2011-10-21 : 09:27:08
|
| Can you please explain me in detail how to see thatshashi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-21 : 09:43:37
|
| in management studio you've icon to display the execution plan on top. click it and then run your query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Performance Problem