What is the use of maintance plans in SQLSERVER2005
Can anyone tell me what is the need and use of sqlserver maintanance plans and how to configure them. ...
maintenance
Put a website in maintenance mode?
Hi. I've developed my first web application which, surprisingly, is getting very popular. Because the website is now live, I have a hard time doing some changes, in fear some people are still logged in and are using the application. I wish to avoid having a duplicated instance of the web application for testing. Is there any way to...
Serious help on maintaining an ongoing project
Hello, A whole team of programmers who were managing a project in our company have left the company to start their own venture. Now,How do I carry on? itseems quite hopeless. Please advice... Thanks ...
What qualifies as maintenance vs. adding new features?
Where should the line be drawn between maintenance and new features? The Oxford English Dictionary defines maintenance as: (7.a) The action of keeping something in working order, in repair, etc.; the keeping up of a building, institution, body of troops, etc., by providing means for equipment, etc.; the state or fact of being so kep...
MSSQL: Does last_user_update mean that the index hurt performance?
I've written a query to look for indexes that are not used in the production environment in order to drop them, however I'm curious whether the last_user_update column is an indication that the index was solely a maintenance overhead, in which case it would be good to drop it, or whether the index helped the performance of the insert/upd...
when were index statistics last updated?
Is there a quick and easy way to list when every index in the database last had their statistics updated? The preferred answer would be a query. Also, is it possible to determine the "quality" of the statistics: FULLSCAN, SAMPLE n, etc. EDIT this worked for what I needed, a slight mod to @OrbMan great answer... SELECT STATS_DATE(...
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 supposed to run a Maintenance Clean Up task to delete any .bak files in the folder the back up task saves to that are older than 5 days. My backups are being created, but my old files aren't being deleted. I don't see any error...
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/trunk structure under them like this: Project 1 - trunk - tags - branches Project 2 - trunk - tags - branches This goes on for ~40 projects. What I would like to do is clean up any abandoned branches that may exist, however I do...
Facebook App maintenance considerations
If I write a Facebook App for a client (I'd probably be the "developer" working with a marketing agency, with one or more Facebook apps as market of a social media strategy), it's not just a fire and forget project, is it? From what I've read so far, the Facebook API is still in flux, and fixes and changes that Facebook makes can break ...
Monitor web application with perfmon for application spesific trends over time
Hi I would like to have a better view of what the application is doing. We are monitoring the ASP.NET and .NET counters but we need a deeper view of what is happening, and how fast it is happening. What is best practices regarding this, and is there specific guidance or documents available for the Microsoft.NET environment? Would I us...
Tips for maintaining an internal Maven Repository?
I'm interested in maintaining a Maven 2 repository for my organization. What are the some of the pointers and pitfalls that would help. What are guidelines for users to follow when setting up standards for downloading from or publishing their own artifacts to the repository when releasing their code? What kinds of governance/rules do ...
What percentage of your time is typically development vs. maintenance?
And as a related question, what factors determine how much of your programming is split up between development and maintenance? I know this is a highly subjective question, but I'm wondering where software application development tools can add the most benefit, on making the development faster or making the maintenance easier? Thank yo...
How can I create a 'maintenance mode' for SharePoint?
I need to disable access to a SharePoint application between 6 PM and 7 AM. SharePoint 2007 doesn't seem to have an out-of-the-box "maintenance mode," so I'm looking for a solution. Presently someone moves users out of a security group to limit access to the application, so in the very least, automating that process would work. Is there...
Jobs to improve database availablity and performance
can anyone suggest Jobs that will improve database availablity and performance in sql server 2008? ...
SQL Server: Way to syntax check all stored procedures?
i want to ensure that all stored procedures are still syntatically valid. (This can happen if someone renames/deletes a table/column). Right now my solution to check the syntax of all stored procedures is to go into Enterprise Manager, select the first stored procedure in the list, and use the procedure: Enter Alt+C Escape Escape Down...
Is there any tool to track source code contributions made to a project?
To protect ourselves from later patent claims etc. we feel the urge to track contributions being made to the core code of a future open source project. We thought of the following procedure if we get contributions: a contributor has to do a quick registration with us if he commits more than just small bugfixes to our main codebase (st...
Convince the need of maintenance, updates and recoding
One of my favorite topics to discuss with my boss is the need for maintenance work, doing code updates and refining existing code with new techniques. Especially things like: a new Telerik controls update (got to love breaking changes). How do you convince your boss? ...
How to maintain a locally modified copy of an external svn repository
I have checked out an external svn repository that I have applied a couple of patches to. (Applying the patches can only be done manually due to conflicts.) Now I want to be able to maintain this local copy of the remote repository in a proper way. (I do not have any other access rights than read on the remote repository.) First of all...
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 rows of data in a table that will be quite large even without them (still in the millions). I can easily find these duplicate rows and can run a single delete query to kill them all. The problem is that trying to delete this many rows in on...