How to make Sql server Performance faster?

Question

How to make Sql server Performance faster?

chethandotnet-678503

SSC Rookie

Points: 25
More actions
March 22, 2008 at 5:13 am

#185464

Hi,
I am using sql server database we have 30,000 records from which we want to find specific records sorted through indexing.I want the information about how to improve the performance faster.Can any one help me.
Thanks
[font="Comic Sans MS"][/font]
Chethan Kumar.U
Software Engineer.
Nipi Software Pvt. Ltd.
Vijayanagar, 2nd Stage,
Mysore-570017.
Ph: +91-9900388711

Viewing 3 posts - 1 through 2 (of 2 total)

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

sqlagentman SSCarpal Tunnel Points: 4484 More actions · Answer 1

Perhaps a little more information is in order: Can you tell us how you expect to search these records (what column(s) are expected to be in the WHERE clause of the queries involved, how frequently is the table/tables going to be queried? How long is it currently taking to query the results? What are the data types of the columns in question? What keys or constraints are set up in your table(s).

Your intitial email does not give us enough information to make suggestions.

- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

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

With the information provided, all I can say is did you remember to hit the "Run SQL Faster"? 😀

Seriously, though... we need a bit more information. First, 30,000 rows is nothing so far as a database goes. If you want "it" to run raster, then you have to describe what "it" is... in other words, post the procedure or script you want to run faster AND click on and read the URL in my signature line. It will help us help you a lot better...

--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)