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

Poor Man’s Cube Style Slice & Dice In A Query

This weekend I had the privilege of volunteering the Give Camp in Charlotte.  Give Camp itself is an annual national event where technical people volunteer their time over the course of a weekend to build a solution for a charitable or non-profit organization that could use the help. In my case, I was with in … Continue reading Poor Man’s Cube Style Slice & Dice In A Query