The DMVs are queries that allow you to retrieve valuable metadata information about your data model, server operations, and server health. What are the DMVs The DMVs queries are an interface to schema rowsets based on SQL and use a SELECT statement and the $System schema with an XML/A schema rowset, however, they do not support the full syntax of…
This second article is focused on best practices for designing your data model, optimizing CPU, RAM, and workspace capacity consumption by minimizing memory usage. Benefits. Reduce space and processing time. Faster refresh times. Lower latency reports. Reduce the time development. More user-friendly data models because the user will not navigate through a bunch of useless…
Is your data model turning into an unfriendly monster full of unnecessary columns and measures with long refresh time? Or after cleaning up your data model, do you find that connected reports break so you manually go through each one to find the cause? In this post I will introduce you to the first version…