I run an online photography community and it seems that the site draws to a crawl on database access, sometimes hitting timeouts. I consider myself to be fairly compentent writing SQL queries and designing tables, but am by no means a DBA... hence the problem. Some background: My site and SQL server are running on a remote host. I u...
I maintain a couple libraries for other people. After having gone through a couple releases for each of them, there are some things I would do differently, if I had to do them over again. The question is: Should I do them over? I guess we all face that dilemma - how to balance the helpfulness of the maintenance activity versus the d...
This may not be the best title - I would appreciate it if someone would come up with a better one after reading my problem. Also, I want to say up front that I am largely self-taught on the Internet, so there may be many tools that I am not aware of! I am maintaining software implementing the Flow-Based Programming concept in both Java...
Is there any tools to check for dead code for PHP5? Something like Scan classes with Reflection Follow "normal" code with token_get_all() and find variables with token T_NEW and then scan for method calls. Output something like classname (count of new declarations) methods (count of calls) ...
I am a senior software engineer, and a few months ago I have been asked to help with co-ordination of bug corrections. The project manager (non technical) has given me an objective of improving productivity to 1 bug correction per man/day. This has been a real challenge, and I would like to know what other developers/managers may have do...
I have started to feel that using regular expressions decreases code maintainability. There is something evil about the terseness and power of regular expressions. Perl compounds this with side effect like default operators. I DO have a habit of documenting regular expressions with at least one sentence giving the basic intent and a...
Does anyone has some tool or some recommended practice how to find a piece of code which is similar to some other code? Often I write a function or a code fragment and I remember I have already written something like that before, and I would like to reuse previous implementation, however using plain text search does not reveal anything,...
Just wanted to hear some words of advice (and comfort.. ) that will help me to take control over some complicated spaghetti code -- code that was developed by multiple programmers (usually that never meet each other) over long time. the solution's features are just patched on top of each other. Usually I tend to see 2 kinds of programme...
It seems probable our client will cancel the project we've been working on for 15 months. It's possible (although not very likely) that it will get restarted at some point. We've also extended our company's product in several areas while doing this. Other project teams may need to make similar extensions, and we'd like them to be able...
We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to exclude column(s) from a table without specifying all the columns? SELECT * [except columnA] FROM tableA The only way that I know is to manually specify all the columns and exclude the unwanted column. This is really time consumin...
I am trying to create a script that will keep 5 folders or 6 months worth of folders, whichever is greatest. I would have to use the created date for the 6month part of the script since the naming convention is by version rather than date. would anybody have any ideas about the best way to proceed? Thanks. ...
I'm doing Yet Another PHP Framework for the fun and sport of it, and I'm doing the first rounds of documentation. I'm planning to code a little, document what I've coded, code some more, adjust the documents to reflect the code's new abilities, repeat. For example, the configuration is pretty manual and tedious at the moment, but I'm doc...
Hi there, I need some advice on SQL Server 2005 maintenance plan, okay here some question: What task(s) is/are suitable for daily maintenance and what for weekly/monthly maintenance Do database need to be offline while in some task, example : reorganize/rebuild index, Shrinking database, etc... (since we need to keep 90% uptime) How l...
Hi Everyone, I'm trying to debug a problem with a perl application that calls some c programs to do text editing. BATCH_JV_CSH_MAX is used to test the maximum value of an amount field. It currently indicates an error if the amount is over 99,999,999.99. Is is supposed to accept values up to 999,999,999.99. Well, that is what is stat...
In a big project where you have lots of resources (resx) what would be the right approaches and/or tools of translation in order to save time, at the same time keep everything in order and leave nothing behind. More precisely, how to find (as far as translations are concerned) what has been modified (adds and removes are easy) of an ent...
We have been using SVN at my workplace for a few years now and we really haven't done any kind of maintenance on it besides updates and backups since we installed it. Is there anything else we should be doing to maintain SVN or is what we've done all we really need to do? ...
I'm working in a 12 year old code base which I have been the only developer on. There are times that I'll make a a very small change based on an intuition (or quantum leap in logic ;-). Usually I try to deconstruct that change and make sure I read thoroughly the code. However sometimes, (more and more these days) I just test and make s...
Right now i currently using transactional replication with updatable subscription. Is there any ways (including T-SQL) that can use to shrink down distribution database used within replication schema? The file was named distribution.MDF Also i found quite large data stored on folder repldata, is it save to delete this files? And how? O...
We have been developing SSIS packages for about a year now, and have 2 major issues associated with the maintenance of these packages : 1) We are using version control, but trying to identify the changes between versions of packages is a nightmare - the results of a text diff between 2 versions of a package is basically unusable. 2) Fo...
I would like to know, for those of you who are one-man bands especially, how much of your time is spent maintaining or supporting your programs, as it compares to everything else you do in your day to day business. I worked in telephone-based tech support for a large ISP for two years, and I still have nightmares about that. I can get m...