SQL Parameter sniffing on other columns than DataAreaId or PartitionId / literals
Ever faced performance issues due to parameter sniffing on other columns than DataAreaId or PartitionId?
What if we could have more control over the fact which column is handled as a literal (and not as a parameter) in the query?
Microsoft Dynamics 365 Finance and Operations, Ent...
SQL hints X++ / SQL Parameter sniffing
Some queries and their individual data composition in the different companies sometimes really require specific query tuning.
Microsoft Dynamics 365 Finance and Operations, Enterprise edition has the functionality to disable parameter usage for the entire query using forceLiterals, this...
How about a good index statistics overview for a given table?
Within lifecycle services for production performance troubleshooting it is essential to get insights to the actual index design and usage from production. Samples: - To avoid suggesting indexes, that are mostly already there (just some additional included columns missing) - To avoid adding too...