How do you decide which parts of the code shall be consolidated/refactored next?
Do you use any metrics to make a decision which parts of the code (classes, modules, libraries) shall be consolidated or refactored next? ...
consolidation
How to build a consolidated pivot table when the source data contains column headings that are dates?
I have a customer who is currently using Excel to do their staff planning. They have many workbooks for different projects and each project contains 1 or more sheets containing the actual staffing data: The customer wants to consolidate all of the data from all of these many sheets and workbooks into a single pivot table. A 'consoli...
SQL Server Replication, Consolidation
How do I consolidate multiple publications into 1 consolidated table on the subscriber? For example. Consider a very simple sales model where we replicate sales data from the stores to the central office. Store 1 Sales Table ===================== Item Qty Amt ===================== 111 2 10.00 222 1 ...
Consolidating / Clustering Terms and phrases
Our application allows a user to enter company names that their organization works with. A current issue is that the way one user inputs the company name varies from user to user. We need to consolidate this data. Are there any proven approaches for tackling this problem? ...
How to do regular database cleanup in a JPA application?
Short background: I have a software that regularly downloads files. The Statistics of these downloads are stored in the database as a DownloadResult entity, which is in turn associated to the entity representing the download job. Now I want to make sure, that only a fixed number of the n latest downloads are preserved in the database. A...
Local SQL Server 2008 Express data upload to Web based SQL Server 2008.
Over the next few months, we need to consider the best technology/technique for periodically uploading SQL Server 2008 Express data that is held on a local network up to a Web based SQL Server 2008 server. The idea is to allow us to consolidate the data in 20 distributed (local) SQL Server Express 2008 apps in use throughout the country...
Condensing repeating JQuery code
I have a page that has a large image on it with a number of thumbnails. When you mouse over a thumbnail the main image changes to the image you have just rolled your mouse over. The problem is the more thumbnails I have, the more repeated code I have. How could I reduce it? The Jquery code is as follows. <script type="text/javascript">...
Script to copy files on CD and not on hard disk to a new directory
I need to copy files from a set of CDs that have a lot of duplicate content, with each other, and with what's already on my hard disk. The file names of identical files are not the same, and are in sub-directories of different names. I want to copy non-duplicate files from the CD into a new directory on the hard disk. I don't care abo...
ANY way to consolidate this code?
I am building a PHP registration form which takes the following fields for up to 20 athletes: First Name Middle Initial Last Name Federation Number Address City State Zip DOB SSN Phone Email I am only through 7 of the fields for each fighter and my php file is very large (over 40kb). Is there ANY way to consolidate this code at...
Condensing vb.net code
I have the following code: Private Sub txtFileFromLocation_TextChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.TextChangedEventArgs) MachineNameUIDisabled() ServiceNameUIDisabled() ToLocationUIDisabled() btnSubmitUIDisabled() lblStatusClear() End Sub Private Sub txtMachineName_TextCh...