Thank you!!!

great idea, i will try first creating a temp table before the transactions, if that doesn't help then i am going to create a table in my db.

thanks a...

thank you Manu, that's exactly where i got it from. My question is , in the article it says to check for values in the thousands for the CPU,...

is there a way to download a trial version of DBPro's schema view? I have visual studio 2005

i have redgate data compare, can i use that?

Thank you so much!

thanks, should i also include the error and warning events ? the error i am looking for is for ambigous joins.

Thank you guys, i apreciate it. 😀

I was checking for locks and blocks in the actual database being used, i did'nt know to check also in the tempDb, i will do so. Thanks for the...

how do i know when i need to defrag?

ok i will, but it seems that there is still 2 GB missing somewhere, i add up everything and still there is 2 GB missing somewhere. At least is not...

around 2.3 GB, can i move the c:\windows\servicepacks to the d drive?

yes it is, it is showing 17.3 GB total , 20.9 MB free. Does the Pagefile.sys have to be that big? i am running a windows xp with 1.99...

nice.... thanks! ok i did, my windows and program files taking total 15 GB, and then the pagefiles.sys taking 2,345,555,496 bytes..what can i do about that?. I heard also that...

I don't thave the internet enabled in the box. :blink: