If you ever felt a need to perform a query to check for a particular text instance in all sources (SPs, functions, triggers et al) in your SQL 2000 db, chances are you might have already written this little goodie. But if you haven't and if you need some
Read More...
There has been a long-standing doubt about the performance of the count statement. I was told by experienced developers in PL/SQL that using count(1) to find the rowcount was much more high-performing than using count(*), as count(*) fetches all the rows
Read More...
