Project #33182 - Information Technology

Each answer should be about 100 to 300 words. An answer should be focused on answering the question, and not give more information than necessary. If you use one or more references for your answer, use in-text citations and give one References list at the end of Part 1. An in-text citation from a book should include a page number or page range.

  1. Find one or more of the following articles:

    • The Microsoft Technet article, "Advanced Query Tuning Concepts"
    • The madeira.co.il article "LOOP, HASH, and MERGE Join Types"
    • The article by Randy Dyess, "Optimizer Join Methods"

    Pick ONE of the three join methods, and state:

    1. What the join method is and how it works

    2. Under what circumstances will that join method probably be used (25)

  2. Describe the following:

    1. Under what circumstances will the SQL Server query optimizer choose to use a nonclustered index plus a key lookup?

    2. If the query plan in 1 is cached, under what circumstances will the performance of that query be very poor, and why? (15)

  3. Given the mantra, "Fewer page reads means better performance," describe how an index can improve performance. Refer to one or more figures in the textbook if that helps your description. (10)

  4. Describe three things you can find out using a graphical execution plan; for each item, describe how you determine the item, and explain why that item is important to know. (15)

      f.Compare and contrast a clustered and a nonclustered index in SQL Server. (10)

      g. Why is a surrogate, integer, sequential primary key (and clustered index key) better than a globally unique identifier as a primary key (and clustered index key)? (10

      h.You have created the Sales.Customers table with a PK of custid and the Sales.Orders table with a PK of orderid and a FK of custid referencing Customers(custid). Your applications run many queries that join these two tables and search for orders placed on a certain date or in a date range. What index or indexes would you create to support these queries, and why? Clarify any assumptions you make about the queries. (15)

Part 2. “big data” Essay (100 points)

Write a 300- to 500-word essay about “big data .” What is it? How does it differ from data in relational databases? How is it used? Who uses it? Why is it important? Why should you care about it? What opportunities and challenges does it present?

Use a minimum of three good sources of information. Cite sources properly, using in-text citations and double quotes where appropriate, and have a proper references list at the end of your essay. At least 75% of the writing must be in your own words.

Review the grading rubric below before beginning this activity.

Subject Computer
Due By (Pacific Time) 06/16/2014 05:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy