Not sure how much this would help, as I've not done this, but when dealing with the order of dependencies there is the a system procedure ,sp_depends, that...

And you did not rename of Excel sheet ,it is still Page1 ( I dont know if trailing spaces in the name  would make a difference but might as well...

I would also throw in there to check that you or someone else does not have the Excel file open.

In your data you may have sales where State is a column, along with storeName. If you want want to rank your best selling stores you can sum sales and...

I'm glad I'm not the only one that missed the SET as I was thinking SELECT as well. Nice one Steve.

I uploaded some pictures to help illustrate what was mentioned in a prior post. You can right click the database, select the tables you want to script out and what...

I wonder if the SSDs are identical, as in reads/write (throughput? ) per second and such.

This will give you a list of the system views that have information on check, default, and other constraints > 

select * from sys.all_views
where...

Is this a solution that was created on another machine that you are now trying to run on yours? DO you have the Integration service running (not just the SSDT...

Do you know if something was thrashing one of the disks? That is, some process doing some intense read or write? An anti-virus would make sense. If you approach the...