On 4/26/2011 1:07 PM, Stephen Russell wrote: > On Tue, Apr 26, 2011 at 11:52 AM, MB Software Solutions, LLC > <[email protected]> wrote: >> 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. >
I'm just saying you'd better be fixing problems that they know about instead of creating ones where they thought things were fine. But you know that. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
