Reduce DataBase Size

Dear friends,



iam usin p6 v8.1, sql



the data base is very slowww. the MDF file size is 3.40 GB and LDF file size is 5kb . i tried to delete some projects to decrese the size of MDF file to make it more faster, but the surprise that after seleting 4 projects the size is increased to 3.5 GB. I made shrink for the data base but this dosn't help. there is one file on these forums oncluding some queries like:



update statistics project with fullscan ,all

update statistics task with fullscan ,all



&



exec sp_updatestats



But also this doesn't help. and the problem is the data base became more slower after deleting these projects.



Please i need quick help



Thanks

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts