@Lynn : i guess you are right, if they can "at least" update the documentation 🙂

Yes,, i have no problem to have different behavior
I have problem about the communication to us where Microsoft says "it is exactly the same" and it is not
Of...

Thanks @grant and @Lynn
What i found really weird is your explanation is valid for alter not for drop
drop table if exist will not fire the trigger...

Yes it may be expected but if you do a "drop table if exists" the database trigger is not fired
drop table if exists dbo.my_table

This look...

try something like this : 
  NON EMPTY
   {
    (
    STRTOSET(@Owner) *
    [Job].[Job].[Job].ALLMEMBERS *
    STRTOSET(@FY) *
    [Date].[Simple Date].[year].[2018].children * --assuming month is the...

here the 2 execution plans

the good plan is generated by sql 2008R2 (the same is generated with compatibility level 100 or by using the traceflag 9481)

again the query is really...