I think this decision further demonstrates that Microsoft is out of touch with their customer's needs.  Releasing a major version of their software in a year and a half, and...

With that setting it will use the Windows account that the SQL Agent job tells it.  If you look at the step in the SQL Agent job, there will be...

Maybe it would be easiest to import into a temporary table then unpivot to put into your real table?
Here's an article about unpivoting using CROSS APPLY which I've found...

I can't really help with the AG aspect of this, but it would seem strange that a Windows issue would affect a SQL Authenticated login.  Have you looked at the...

You would have to collect this information periodically over time, using queries from the Ring Buffer or DMVs like Arsh mentioned, and then query the collected information for your weekly...

...or we just need to install that new clairvoyance plugin into our browsers.

I thought that the duplicate stats do not automatically go away?  Here's an article that suggests even automatically created stats will stay when they are duplicated by an index's stats...

In Kimball Group Reader, on page 339, they talk about "Multi-Enterprise Calendar Dimensions" which is what I believe you are trying to implement.  In the Kimball example, they have a...