Where did he ever get the idea that either style would default to an implicit outer apply, apply in general is newer than either join syntax....

But no both...

hmm... the footprint for adding winscp should be pretty small.  I don't know why they would need putty on there just to transfer files(although that should also be a very...

The DOP needed is determined by the query optimizer for each statement that is run(unless you over ride it with a query hint), I don't think there's any concept of...

Why are you trying to keep the constraints?  If you know they're enforced in the source data and you aren't modifying the data in the DW there is no reason...

Yes those are different indexes(ignoring that one will be clustered and one is non clustered) and can potentially be used differently by the optimizer.  Also the second index has a...

You can try something like this,

1.Set MonthNumberV2 = month([date])
2. Set MonthNumberV2 = month(dateadd(month, -1, [date])) WHERE [date] < DATEADD(day,
IIF(DATEPART(weekday, DATEADD(month, DATEDIFF(month, 0, [date]), 0)) = 1,...

It mostly looks like it's carrying the previous month number through the first saturday of every month except you have one day in there 2017-06-04 that's a sunday...  ask the...

Well yes your trigger is set to only run on updates 😀

Change FOR UPDATE AS to FOR INSERT, UPDATE, DELETE AS

It looks like you'll also...