MicrosoftLearning / dp-300-database-administrator

Repository for lab exercises and instructions for Microsoft DP-300 learning content
https://microsoftlearning.github.io/dp-300-database-administrator/
MIT License
81 stars 89 forks source link

Lab-10-isolate-problem-areas-poor-performing-queries: query syntax error due to auto-type option #19

Closed vipaiva closed 2 years ago

vipaiva commented 2 years ago

Module: 05

Lab/Demo: 10

Task: Generate actual execution plan

Step: 01

Description of issue Error: image

Module: 05

Lab/Demo: 10

Task: Use Query Store to detect and handle regression

Step: 07

Description of issue Error: image

Module: 05

Lab/Demo: 10

Task: Use query hints to impact performance

Step: 02-03

Description of issue Error: image

Module: 05

Lab/Demo: 10

Task: Change the query to use a variable and use a Query Hint

Step: 02-03

Description of issue Error: image

Suggestion to fix all those syntax errors: install SSMS and disable the IntelliSense option in the VM image. Alternatively, provide the script as an asset in the GitHub repository.

JulianePadrao commented 2 years ago

Thanks for your comment.

Before initiating the labs, we have the following alert note part of the instruction: When copying code from the lab exercises into the lab virtual machine, occasionally line breaks will not come across properly. Please verify that the code is correctly copied before executing it.

We also think the IntelliSense is an important tool for students during the lab.

For now we will keep this issue closed, and we can reevaluate it later on if needed.