Yeah, there are some conditions that have to be met, such as the window...

Ran into this issue myself some months ago. Even wrote a blog post about it (shameless plug ahead!):

Beware the defaults! (in windowing functions)[/url]

The book by Itzik describes this behaviour in...

Thanks for posting this. I had the exact same issue at a client, so now I know it's not our fault 😀

1. Depends. If the 3 SQL DBs are on different machine, you can just use one config file but you change the values when you switch machines. If the 3...

The easiest option would be to calculate the totals in the SQL script at the source.

SSIS cannot put formulas in an Excel sheet.

Easy one, since I once installed SQL Server on a Windows Core machine (as practice for the certification).

Took me a while to see the difference between answer 3 and 5...

Seems pretty darn obvious to me...

Good to know. Nice question, thanks.

Regarding the MERGE JOIN, does it do a inner, left or full join?

If inner, can there be multiple matches? If there aren't, you can use a lookup instead.

Shame on your teacher 😉

patricklambin (3/30/2015)

---

You could find a possible explanation in this link

As I am registered for CodeProject , I have already read this article and I got easily the point.

I have also...

Such a bad habit to start a CTE with

;WITH

I hate it 😀

Nice question though, thanks Steve.

Nice question, thanks.

tcuddington (3/27/2015)

---

Let me make sure I'm following this: I can set up an app server to house SSIS, point SSIS to store packages on the actual db server in msdb....

Right. I have encountered the same issue before. I even blogged about it:

The OLE DB Source and the Oracle Date...