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

My shot at free expert level training from SQLSkills

There is only one reason for this post – To immerse myself in the SQLSkills training giveaway “Master Immersion on Internals and Performance” on SQL Server and meet both Paul and Kimberly (the people behind SQLSkills) in person. You can read the complete details here. A few days ago, I saw Paul’s Tweet about a giveaway of … Continue reading My shot at free expert level training from SQLSkills