Top "Maintenance" questions

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

Visual Studio setup problem - 'A problem has been encountered while loading the setup components. Canceling setup.'

I've had a serious issue with my Visual Studio 2008 setup. I receive the ever-so-useful error 'A problem has been encountered …

visual-studio visual-studio-2008 visual-studio-2005 installation maintenance
ResultSet: Retrieving column values by index versus retrieving by label

When using JDBC, I often come across constructs like ResultSet rs = ps.executeQuery(); while (rs.next()) { int id = rs.getInt(1); // …

java optimization jdbc resultset maintenance
Check when password was last changed

How do I check when the password was last changed for some user? I would like to do it both …

windows linux passwords admin maintenance
How can I copy data records between two instances of an SQLServer database

I need to copy some records from our SQLServer 2005 test server to our live server. It's a flat lookup table, …

sql-server database sql-server-2005 copy maintenance
How does one decompile and recompile a database application?

I have an Access database application and I would like to know the proper way of decompiling and recompiling it.

ms-access vba maintenance decompiler
Deleting millions of rows in MySQL

I recently found and fixed a bug in a site I was working on that resulted in millions of duplicate …

mysql query-performance maintenance sql-delete
Patch vs. Hotfix vs. Maintenance Release vs. Service Pack vs

When you are somewhere between version 1 and version 2, what do you do to maintain your software? The terms Patch, Hotfix, …

maintenance patch servicepacks hotfix
SQL Server xp_delete_file not deleting files

I'm trying to write some SQL that will delete files of type '.7z' that are older than 7 days. Here's …

sql sql-server maintenance
Listing each branch and its last revision's date in Git

I need to delete old and unmaintained branches from our remote repository. I'm trying to find a way with which …

git maintenance administration branch
When should database indexes be rebuilt?

I was reading about refactoring a large slow SQL Query over here, and the current highest response is from Mitch …

mysql indexing maintenance