Top "Maintenance" questions

The concept of keeping software or hardware functional in a productive environment

How to disconnect all users in sql server except sa?

I would like to disconnect all users from SQL Server except sa. The need for this is: I wrote a …

sql-server sql-server-2008 maintenance
How do I monitor and find unused indexes in sql database

I would like to monitor index usage for an sql database, in order to find unused indexes and then drop …

sql-server indexing maintenance
drop user cascade in Oracle

I need to be able to drop a specific user (which may have active sessions) from the batch without any …

oracle maintenance
How do I easily find IDENTITY columns in danger of overflowing?

My database is getting old, and one of my biggest INT IDENTITY columns has a value around 1.3 billion. This will …

sql-server overflow maintenance identity-column information-schema
Visual Studio 2008 / C# : How to find dead code in a project?

How do I find dead code in a Visual Studio 2008 C# project? Like unused classes, unused variables or unused resources?

c# visual-studio maintenance
Apache: enable maintenance mode across all virtual hosts

I have a server running Apache with several VirtualHosts e.g. domain1.example1.com domain2.example1.com etc. All these …

apache virtualhost maintenance
Put a website in maintenance mode?

I've developed my first web application which, surprisingly, is getting very popular. Because the website is now live, I have …

asp.net maintenance
Implement "Down for maintenance" page

I know we could simply use an app_offline.htm file to do this. But I want to be able …

asp.net-mvc asp.net-mvc-3 maintenance
Is there a way to visualize an entire SVN repository?

I have an SVN repository that has multiple projects inside of it, each one of those with a tags/branches/…

svn repository maintenance
SQL 2005 Maintenance Cleanup Task .bak files not being deleted

I have a SQL 2005 Maintenance plan that runs a backup to create a .bak file, and, on successful completion is …

sql-server-2005 maintenance