how to improve qurey perpormace

Question

Post reply

how to improve qurey perpormace

pradeepmsbi

SSC Veteran

Points: 257
More actions
May 2, 2010 at 4:22 am

#222086

how to improve the query performance in sql server 2005

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Paul White SSC Guru Points: 150467 More actions · Answer 3

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 4

pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005

you can find good article here http://www.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;-)

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 5

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 Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning