Your problem may be less than optimally designed tables or queries. (perhaps index or trigger related) but there is also a good chance this is related to insufficient hardware....

Thanks guys. I'm on track now.

This could be an interesting thread. I'm curious how others handle this as well.

For myself I don't use maintenance plans at all. I hace a stored proc that...

see also http://www.sqlservercentral.com/scripts/contributions/946.asp

This may be a real SQL Server bug.

Check out if this applies:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885

Using EM Right Click on the original large database, Choose All Tasks, the chose Shrink Database. At the top of this window you should be able to see the...

Backup or truncate the transaction log before doing the Shrinkfile. (Don't truncate the log if you might need it for recovery)

I see nothing wrong with running MS supplied procedures like DBCC DBREINDEX or DBCC INDEXDEFRAG followed by UPDATE STATISTICS. As you add and remove records this is something that...

Microsoft has created a series of building blocks for .Net development. There is a data layer building block which is great. See http://www.microsoft.com/downloads/details.aspx?FamilyID=76fe2b16-3271-42c2-b138-2891102590ad&displaylang=en

There is methods in this data...

ODBC is Open Data Base Connectivity, which is a connection method to data sources and other things. It requires that you set up a data source, or what's called a...

John Howie wrote a good article about this see http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/prodtech/dbsql/sql2kaud.asp

Try SQL Buddy which is like Query Analyzer but released as open source (see http://sqlbuddy.sourceforge.net/about.shtml)

Edited by - fhanlon on 12/04/2003 10:37:55 AM

Can you attach to the MSDE instance from a machine with client tools on it and then use EM or the sp_password command? Another alternative is to install client...

Sorry for not understanding... Are you saying that SQL is using 1.7G memory , Windows is using the .3G and nothing is using the additional 1 G added?

Shrink the database and rebuild indexes to get rid of fragmentation. If the MDF file itself is fragmented run a defragmentation program when SQL Server is not up. ...