On Tue, Apr 26, 2011 at 11:52 AM, MB Software Solutions, LLC <[email protected]> wrote: > On 4/26/2011 12:40 PM, Paul McNett wrote: >> On 4/25/11 2:13 PM, Stephen Russell wrote: >>> Would you attempt to normalize this structure to Locations, People, >>> ContactTypes? >> >> Would doing so simplify the application meaningfully? If so, then I would >> argue for >> it. If not, then no. > > > Right. There has to be a business benefit to doing it, and not some > purist and/or MS-Way point of view only. Otherwise you put a working > system at risk for failure for no good reason. --------------------------
Current system is a cluster flop in tables and SPs. Last count of SPs was > 4000 Probably only 350 tables I have not queried the total yet. I still find in SPs Delete XYZ instead of Truncate Table XYZ Then they say that the Trans Log for 15 min is over a gig. Fixing lazy programming is helpful to the entire system. Putting it into place takes having to learn something new for most of out team but in this industry you have to learn new stuff every day right? We do a LOT of heavy lifting of data hourly via SPs so there are tons of them that have nothing to do with CRUD operations on a single table but reach over 5 or more tables. -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
