To ensure that the changes wouldn't break anything existing, John used the "Database Comparison" feature in SSMS. He right-clicked on the database and selected "Tasks" > "Generate Scripts".
In the "Generate and Publish Scripts" wizard, John selected the database objects to compare and chose to generate scripts to a new window. He then compared the scripts to the original schema to ensure that no unintended changes were made. sql studio 2014
CREATE NONCLUSTERED INDEX IX_FactSales_OrderDate_Include ON Sales.FactSales (OrderDate) INCLUDE (CustomerID, ProductID, Revenue); To ensure that the changes wouldn't break anything
Select "Management Tools - Basic" and "Management Tools - Complete" to ensure all required GUI tools are installed. sql studio 2014