microsoft-dynamics Archives

Viewing execution plans for queries with parameters

By adminPosted on March 16, 2023

Question : I have a sample query generated by an application (Microsoft Dynamics AX 2012 in this case) which is […]

By adminPosted on November 13, 2022

Question : I have slowness. Can anyone review this plan (PasteThePlan) and tell me what I need to optimize? This […]

By adminPosted on October 4, 2022

Question : I am an accidental DBA at my work, and when I took it over, it was quiet a […]

By adminPosted on September 3, 2022

Question : I’m working with a 3 tiered application, Microsoft Dynamics AX, where the middle tier maintains connections to a […]

By adminPosted on August 27, 2022

Question : So I found tons of unused indexes from our CRM application with this query from Pinal: SELECT o.name […]

By adminPosted on April 3, 2022

Question : Using Dynamics 365 with MSSQL. There is an option to enable Full Text Search, however once it is […]

By adminPosted on February 14, 2022

Question : How do I restore a huge Microsoft SQL Server database that is 6GB as a zip file and […]

By adminPosted on July 4, 2021

Question : I have a problem with the following query executing from the application (Microsoft Dynamics AX): DECLARE @p1 INT; […]

By adminPosted on June 21, 2021

Question : I have a sample query generated by an application (Microsoft Dynamics AX 2012 in this case) which is […]

By adminPosted on June 12, 2021

Question : I am looking at a possible fringe case for parallelism settings. I’ve long since followed the credence that […]