Category Archives: SQL

Missing Index Stats Enhancements

Posted on 8. April 2016 by Bennett

Here is my script to find missing indexes using the missing index DMVs. It’s pretty much like others with the exception that I first get the instance uptime and then use that to calculate the number of seeks and scans … Continue reading →

Posted in Performance, SQL, SQL Server | Comments Off on Missing Index Stats Enhancements

Oracle Sysdate formatting

Posted on 23. May 2008 by Bennett

You can use the PL-SQL to_char function to format the output of SYSDATE like this: select to_char(sysdate,’DD/MM/YYYY HH24:MI:SS’) from dual;

Posted in SQL | Comments Off on Oracle Sysdate formatting