Friday, May 26, 2006

Security Warning on MSDN



I got this warning when trying to go to MSDN from a search.

How comical is this!?

Tuesday, May 02, 2006

SQL index tip

This where clause can be made more simple and avoid unnecessary formatting by Oracle if you use the default Oracle format for the date test. Sometimes function calls will cause Oracle to disregard the index.

This:
update rad.dcd10dm
...
where dep > to_date('03/20/2006', 'MM/DD/YYYY');


Can be coded like this:
update rad.dcd10dm
...
where dep > '20-mar-06';