Use the data manipulation tools in SSIS to remove columns you do not need, or to add extra columns with default values; then combine the results.

A normal view is like a macro definition in a third-generation language. It gets replaced by its definition before the query optimizer even sees it.

When you add an index to...

We know way too little about your tables and data, so we cannot answer your questions.

We need:

* The structure of all involved tables, posted as CREATE TABLE statements. You can...

The execution plan you describe is optimal for this query, you will not be able to speed it up.

For future maintenance, you can rewrite the query though. To this:

SELECT A.F_Name,...

If you insist on basing your ideas on relational theory on implementation choices made by Microsoft, then I guess we'll have to agree to disagree on this.

No. But you can use SSIS instead.

I don't understand most of the terms you use about your business, but based on the sample data I think your table design is not normalized.

You'll want to have two...

You'll have to test to be sure, but I expect the answer to be no.

Fragmentation of indexes mostly affects scan performance (which includes seeks that are not for singleton rows!).

Modification...

If you think that datetimeoffset violates relational theory, then you should not take...

ps_vbdev (1/12/2016)

---

Thanks for your reply and sorry for taking so long getting back. My solution just now is to make week53 2015 to week1 2016. The data seem to fit...

Eric, I guess I didn't make my point well enough. What I was trying to stress is the importance of normalizing data as early as possible. If you can normalize...

I like to compare index structures to books. The comparison does not hold all the way through, but it does well for most of the basics.

A nonclustered index is like...

In most cases, the better idea is to stop halfway through that procedure.

(I.e.,...

No.

Sergiy (1/10/2016)

---

DATETIMEOFFSET is not a relational data type.

It contains 2 different values in 1 placeholder, which is prohibited by Relational Theory.

Values with delimiters ("T" in this case) belong to the...