What is the second job called? It doesn't contain '%integrity%' does it?

I have had to resort to using a sql statement from a variable, then set the variable earlier in the package.

I have created a table variable that contains the...

The easiest way is to use ssis to import the data into a table, then execute a sql task that does the update / insert (merge).

Alternatively you could include a...

So the weeks can have anywhere from 1 to 7 days in them?

How is that useful?

"oh look our revenue this week is 7 times last week, good job team!".

sam 55243 (4/29/2013)

If you are always loading a finite date range, and its not feasible to index everything, you might be able to index the DateKey column and filter the...

I've never seen the two inserts done like that, it looks very clever.

Am I right in thinking that you are not actually updating anything in the fact table? DST.[LOAD_DATE] =...

Have you tried executing the proc from SSMS, but run as the user that the application connects to the db with?

Maybe the app doesn't have access to something and an...

Where was the trick?

Does the view have to be schema bound?

Where I used to work there was a common misconception that a schema bound view was the same as an indexed view. People...

I assume its the query response time, not the processing time that's increased.

Did you lose your aggregations?

Have you tried usage based aggregations?

I believe the answer is yes, if you do not filter on the partitioning column you will scan the entire table, unless you have a covering index.

Our fact tables have...

Delegate 1 has done Consent and SafeguardingChildren and so on the JOIN, I will get four records

Consent and the ConsentDate

Consent and the SafeguardingDate

Safeguarding and the SafeguardingDate

Safeguarding and the ConsentDate

Two of...

This might be obvious, but if you don't have version control on the project, its worth renaming the old package before you upload the new one. That way if you...

I am struggling to understand how your diagram shows any relationships.

Is it simply a statement of facts about people?

Does the presence of a row in the HandHygiene table mean...

If you have a date to order the rows, then something like this could work.

SELECT *

FROM (

SELECT *,

ROW_NUMBER() OVER (PARTITION BY Customerid ORDER BY PolicyDateDate DESC) AS PolicyRank

FROMdbo.CustomerPolicy

) AS a

WHEREa.PolicyRank...