May 2, 2010 at 4:22 am
how to improve the query performance in sql server 2005
May 2, 2010 at 5:32 am
lot of one line questions from you; without details, google and research may be your best bet;
look at teh execution plan and determine if any indexes would help; make sure all arguments are SARG-able.
Lowell
May 2, 2010 at 5:40 pm
pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005
It depends... what do you know about SQL Server and T-SQL?
--Jeff Moden
May 3, 2010 at 2:06 am
pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005
Configure the server correctly, improve the hardware, tune the queries, and refine the database design.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 3, 2010 at 6:29 am
pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005
you can find good article here http://qa.sqlservercentral.com/search/?q=improve+query&t=a
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 7:06 am
The general approach is to identify what's running slow and then look at the execution plan to understand what it's doing. It's a rather large topic. Entire books have been written about it.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply