Dennes Torres in Blogs Power BI: When a Power Query Native Query is not enough In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The... 23 May 2022 8 min read
Blogs Dennes Torres in Blogs A real parameterization problem with a plus A few weeks ago I faced this problem: One query on my application was (fortunately in the development environment) was... 12 January 2019 6 min read
Dennes Torres SQL Server Query Plans: Finding Scan and Lookup Problems with DMVs and XQuery Use SQL Server DMVs (sys.dm_db_index_usage_stats) and XQuery against cached query plans to find queries causing scan and lookup problems. Converts... 31 December 2014 15 min read
