Was there some mega rule that I was to drunk to comprehend a couple of years back?
Why would you cast from a Datetime data type to Char(8) and Char(5) 20090611 21:33 ? They don't even have a compound index between the two columns in this system!!!!! Thought that I would use create_datetime but there is no index there so I get a table scan. This is all based around a script to audit a restored backup and compare it to production's live db. I am doing count(*) and count(n) where they can put in an n=number for any column in the table. You know the rule about counting and counting of nulls right? ;-> I was going to have a little web app that allowed our clients to compare their live data against a restore we did for them. They could manipulate the tables and compare all on their own. How many of you have to play this kind of game? -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ 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.
