Month: <span>October 2020</span>

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To show the latest result captured regarding index defragmentation. Sources This feature queries the DMV dm_db_index_physical_stats which returns size and fragmentation information for the data…

Power BI Desktop SQL Server

Power BI Desktop SQL Server

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To see the missing indexes information that the SQL server reports. Sources This feature queries the 3 DMV’s sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details which together returns…

Power BI Desktop SQL Server

Power BI Desktop SQL Server