SQL Server Performance Tuning How to Build an Index

If you're tired of your database-driven website taking "forever" to load or you just want to understand how to add an index to a database table you must watch this video. By using an index you can often speed up your database queries by 5, 10, even 50 times! What are waiting for? Watch the video!

Category:

Howto & Style

Tags:

• sql
• server
• performance
• tuning
• how
• to
• add
• build
• an
• index

[mrp2003]

We are using SQL Server 2005 and VB6, We have a stock table that we insert and query data every minute, The database is about 35MB in size now

The stock table in question has 6,490 records.so it's not considered to be BIG.

Many users connects to Server to retrieve data from the database.

When I call out the stock on the pc. it was very very slow.

is it due to too many data store in the table ?

Any recommend strategies to fasten the DB ?

[vasureddym]

this is very basic stuff

low quality audio :(

[Sheekhow]

cool

[bot06]

Awesome!