To answer your third question that would depend on the isolation level of the transaction. You can override the databases default isolation level with something like

set transaction isolation level read...

. So account name of 'EEERT0450' is unique and will be on source and DW. So when I populate the DW, the process would check if that account already exists...

sipas (11/24/2016)

---

"Number 4 works for this year only."

Actually it doesn't even work for this year.

SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329

SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328

Happy Thanksgiving to all in the...

Jeff Moden (11/22/2016)

---

Phil Parkin (11/21/2016)

---

Jeff Moden (11/21/2016)

---

Phil Parkin (11/21/2016)

---

EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be...

Here too is a resource that can help you get started with graphical execution plans : https://www.mssqltips.com/sqlservertip/1873/how-to-read-sql-server-graphical-query-execution-plans/

There is a button in your SSMS window that displays "include actual execution plan" when you hover over it. You push this button...

Upon further inspection, do you still need the following in the fact table: CounterpartyAccountKey and GenevaAccountKey? I would think these are being replaced with the sourceKey field.

Yes. That appears like a straight forward star schema. One note though is that I would be consistent with the namings. If a column is named sourceKey in the fact...

Interesting that SMALLINT will implicitly convert to INT , but INT wont implicitly convert to BIGINT. Is this the case also with a .NET language like C#?

From what I understand I dont think...

That's how I went about doing it and then had to take a closer...

kevin.obrien 66193 (11/16/2016)

---

The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a...

Jeff Moden (11/16/2016)

---

tnnelzo (6/20/2013)

---

Hello!

Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so that the...

This would be the approach I would take. It is simple to set up Subscriptions...

chocthree (11/14/2016)

---

Thanks for all your replies. Really appreciated.

I have installed the 2016 version of the SQL Server software (as stated in previous posts). I am having trouble finding training videos...