Excellent job!  Looks much better than mine too!!

Some minor adjustments:

The PK for Ticket Response is ( Ticket Number, Ticket Response ID ) (in that order).  Yes, a PK can have...

If I modify the non key index [TransactionGuid] to include [TransactionId] as an included column on the non-clustered index.

No.  Column TransactionId is automatically included in every nonclustered index (including the...

More general notes:

(11) The attributes within an entity should apply only to that entity.  For example, CPZ should be in the Ticket entity only if it CPZ relates directly to...

Here's my initial cut at assigning Attributes to Entities.  I tend to fully normalize, but you can back off of that later if you want to (in technical terms, we...

• This reply was modified 3 years, 3 months ago by ScottPletcher.
• This reply was modified 3 years, 3 months ago by ScottPletcher.

OK, with that out of the way, what Entities do we have for this model?  We must be able to assign each Attribute to an Entity.  I'll make the Entity...

Rules for normalization:

(1) Write names in normal language, no "camel case" naming, etc.

(2) Decide whether you want to use singular or plural names for Entities (there is lots of disagreement...

Not a part of normalization, but I'd recommend you not use spaces in object names -- it will force the use of brackets or double quotes around those names. ...

I've had decades of experience doing data modeling, but I have no clue for your tables.  You haven't described any of the data.

Normalization deals with a logical design, containing "entities"...

Agree 100%.  Talk to the vendor who sold you the license or talk to MS directly.  Licensing is much more complicated now than in the past, so talk to an...

And make sure it is the log file.  That is, make sure IFI is enabled so that SQL doesn't have to initialize all the data files too.

You just re-stated exactly the first line of what I wrote in an earlier post.  What...

I think something like this will do.  And you can change the "INNER JOIN" to "LEFT OUTER JOIN" if you want to show all times ranges for every Q and...

SELECT Convert(datetime, Left(dr_value, 10), 101) as Converted_Date from dr_tracking ;

Focus first on logical I/Os, as that's usually the culprit one way or another.

If you can run the code at will, then add this statement at the start of the...

What is the data of "yourcolumn" (the original column)?

If it's already datetime, and you just want to strip the time off, then do this instead:

DATEADD(DAY, DATEDIFF(DAY, 0, yourcolumn), 0)