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...

anil.nair@gtnexus.com (4/1/2013)

---

I wish SQL Server had a SQL Judge, Jury and Cop rolled-into-one feature which would summarily execute a user once it has used up more than a set of...

ldorian81 (2/11/2013)

---

If you put the whole query into SSMS 2008 and run it without removing the 'GO' commands you will still get the same results as shown below.

Msg 2714, Level...

This is a shot in the dark, buy is the package stored in msdb on one of the cluster nodes, but not another? so that when the cluster rolls over...