DB Spped up

[i i i]

I have one sql server 2005 database and its size is 16 GB , i rebuild indexes on a table which is having size almost 12 GB (item Master) * i know its not normalized but i get the db in this condition dbcc dbreindex (item_master,'',80) and now size becomes 26 GB should i shrink database or physical files showing 50 % free space available. what else can i do to increase the db speed , already check ,Disk I/O , Memory , temp DB , network Packet size. Planning to do

UPDATE STATISTICS item_master
dbcc updateusage ('DB')
DBCC INDEXDEFRAG (DB,'item_master')
DBCC dropcleanbuffers
dbcc freesystemcache ('all')
dbcc cleantable (DB,'item_master') --

Anything else which can speed up the things from database point of view

Best Regards, SOFTDEV If you have knowledge, let others light their candles at it

[_Damian S_]

How many rows are in the table? How many fields? What kind of data is it? Are your indices appropriate for the way you are wanting to extract the data? Can you update the structure to improve the performance or are you stuck with it?

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!