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, E...

Read more...
4 Comments

Read more...
4 Comments

Category: Development (151)

STATUS DETAILS
Under Review

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, thi...

Read more...
2 Comments

Read more...
2 Comments

Category: Development (151)

STATUS DETAILS
Under Review

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...

Read more...
0 Comments

Read more...
0 Comments

Category: Lifecycle Services (147)

STATUS DETAILS
Needs Votes