Start the VM for assignment four. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then select the AdventureWorks2017 database for this assignment.
In this assignment, students will use the AdventureWorks CTP3 database and practice indexing appropriately.
The ability to evaluate and implement various storage structures, index selections, and views is an important aspect of database management.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to provide a screenshot for each.
You notice when running queries that the database is returning results very slowly. Make sure to address the following:
Discuss likely causes for the slow returns.
Propose solutions for speeding up the process.
Explain why implementing the index will speed queries.
Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion.
The sales manager has received a customer request that all products be searchable according to color specifications. In this particular case, the customer is seeking red products. Build a view consisting of ProductID, Product, and Color, and query the new view.
The sales manager presented the customer with the view you created in question three. The customer is still unhappy with the product list because many of the items were not available for bulk purchase or were not yet in storage, which resulted in delays. To address the problem, rebuild the view with multiple joins and filter your query to only look up items from the “Finished Goods Storage” located within the “Name” column from the Location table utilizing LocationID (primary key). Bring in the “Quantity” field from the Inventory table. Rerun the query in the view.
Submit the Word document (with screenshots).
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
need resources and APA
Also I just need the first Two (2) questions answered I’ll complete 3 and 4
I will supply an example