The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

How-To How To Set Up a SQL Express Database for Horizon View It's not hard, but the steps need to be followed carefully. By Tom Fenton 09/26/2017 ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...