I have several small problems with my simple setup. I have MOSS 2007 installed on a Windows 2003 R2 Server that also has SQL 2008 running on it as well. I have about 6 or 7 problems throughout my site ie: Why does SQL take up so much memory Why can't a user's information completely dissappear when I delete them, am I not doing it correctly? Automated messages are not going out to users when a calendar event is created. and more.... Would anyone like to make some money to fix these issues? I have posted here too many times and either no one answers or they dont have the answers. thanks!

SQL Memory- SharePoint is a chatty application and needs the DB server to survive. If you want to limit the memory in use by SQL, then you will need to open SQL Server Mgmt Studio and Right click on the DB instance after logging in and going to properties. In the properties window, choose memory and then set the maximum memory that you'd like to limit to SQL. Be careful not to set this too low as it can create performance issues. You will need to restart the SQL server service from the SQL configuration manager after you update the setting. User Information - Where are you deleting the user. If you delete him from the SSP, then you have not removed him from the site. You will need to delete the user from the site's all people list. However, I am not sure if deleting a user here will remove their name from content that they created since that information is now attached to the list items. Also, many times you want to keep historical information for auditing purposes. Calendar event- How have you configured automated messages? Usually user's have to subscribe manually to receive alerts on lists/libraries/calendars and other SharePoint content. If you want to ensure a message is sent, then you would need to attach a workflow to email the users that need to receive the notification. And more.... keep posting here or contact MSFT so that they can refer you to a Solution Integrator (SI) that can recommend a staff consultant to assist you with your concerns. I work for an SI and we get paid to help out our clients with issues just like the one's you've posted. Help here is freely given, but you can request on demand support through the MSFT partner network. Please let me know if Sogeti can assist you in any way, we have several offices in the USA and abroad.Dan Luciano - Sogeti USA - MCITP, MCTS WSS 3.0 and MOSS 2007 Configuration WSS 3.0 Applicaton Development SharePoint 2010 Admin and Config<--If you find this post helpful, mark helpful to the left!-->