SQL Server: Dynamically Calculate Delta Values For Numeric And Date Columns From DMV’s Or Any Table

DMV's are very useful. In fact, they are like glass windows that lets you look at a running engine. There are lots of them and they give us lots of numbers but Most are cumulative in nature!  i.e., the numbers keep on increasing and never decrease. A variation of above like space usage where the … Continue reading SQL Server: Dynamically Calculate Delta Values For Numeric And Date Columns From DMV’s Or Any Table

Advertisements

Oracle Tip – Generate “N” rows of dates or numbers serially

Sometimes, you would have a situation where you need to generate a table with N number of rows that you can use as the basis to join and restrict other tables. For example, to get the 100 dates starting from a certain date as rows, a typical technique is to select ROWNUM from all_objects to … Continue reading Oracle Tip – Generate “N” rows of dates or numbers serially