I also realize that this post is really old but below is a script I put together that could be helpful to others running across this post. This...

Regarding question #3, let's say I didn't have columns called "Installed" and "Date Received."  I just put those in there to give examples of other fields.  So I I...

1. Yes
2. Yes, and a lot more. On some Fact tables in data warehouses it's not uncommon to have over 100 foreign keys on a table. A foreign key must...

I usually don't accept a method claimed to be "most efficient" without data to support. More importantly, I don't like your tone. Could you please not use words like...

I think you need a new CycleParts table with two columns CycleId and  PartId. You need 2 foreign keys on this table. One pointing to the Cycle table the other...

Why on Earth...

First I would try adding this index to table CommoditySupplier:

CREATE INDEX IX_CommoditySupplier_CommodityID_INC_SupplierID
          ON CommoditySupplier(CommodityID) INCLUDE (SupplierID);

If that doesn't...

lol, I take it that is a joke?

declare @i as int=16
select right('00000'+convert(varchar,@i),5)

Why have you posted this in SQL 2017 when it's for SQL 2014? What do you mean by getting struck? Did you mean stuck? What are you trying to do?...

One other thing it could be is missing indexes, the additional I/O load on the disk can cause high CPU. Have you checked the activity of the disks while you...

It can also make life easier for developers if all the primary keys are integers, it's a bit like having a design pattern that will make coding faster and more...

Just a thought, but instead of

IF NOT EXISTS(SELECT * ... or IF EXISTS(SELECT * ... , why not use Top 1?  all you need to know is only 1...

I think you mean "surrogate" key, as there is no identity column on your table. I would use a surrogate identity column as the PK so create the table like...

Performance Tip: The conditional behavior described for the MERGE statement works best when the two tables have a complex mixture of matching characteristics. For example, inserting a row if it doesn't...