DZone Database Zone
Simple Solution for Metrics Targets on MSSQL
I needed a flexible solution to keep measurements with target values in the SQL Server database. After playing with some tables and functions, I came out with a simple, clean, and flexible solution that also fits well for many other scenarios besides the one I had to support. This blog post summarizes my work and provides all the SQL stuff needed to reproduce it.
Creating and Designing a Metrics DatabaseWe start with creating a database with a minimal set of tables needed to track measurements:
No comments:
Post a Comment