thank you!

ok thanks can i use delete?

thanks, i restarted the services, sqlsvr was using 2.2 gbs for a while but now i checked and is using 3.2 gbs of memory how is this possible? does...

thank you but in task manager i still see:

sqlsvr.exe SYSTEM 00 3,490,568K , do i need to restart services?

thank you it worked :), this is what i have now :

max server memory (MB)16214748364730002147483647

Jonathan regarding

Microsoft SQL Server 2005 - 9.00.4035.00...

thank you again, i am executing this:

sp_configure 'Advanced Options', 1; Reconfigure with override

i get:

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to...

thank you!, question, so how i had it before it was using all the memory all the time? why is this bad?, and now the max will be 3 GBs...

thanks, i will try your ways, just to give you some info these are sps that pass every minute and we were having issues with the caches.

thanks again.

thank you so much, your query works perfectly :-). I finally got visual studio 2008, do you know where i can get the step of how to do the...

thank you what about if the databases are in different servers

i have sql compare but is the version that you can not compare indexes, and i don't have visual studio 2008, do you have another way?

did you find a way to get the included columns?

then if i use one of those scripts to that checks the fragmentation level first, then defrags or rebuilds as needed, what about the sp_updatestats, it won't be needed or...

That is exactly what he said,so would it be better to do add a second job to do this after or integrated into the maintenance package to rebuild the indexes?...

thank you so much!!! one last question, i did this in my testing environment and worked perfectly; however in my production env i have replication, would this represent a problem...