I have also found contradicting information:

Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary...

Nice question, thanks.

Great question, thanks!

Log into the SSIS service, go to the folder Maintenance Plans. Find the one you need, right-click and choose "Export Package".

Or don't export and reference it directly in the Agent...

CASE returns a single data type.

From BOL:

Formatting is best done in the front tool, not...

The columnstore index only slows down your load (but it improves query performance afterwards of course).

Loading the dimensions should be quickly I guess (you haven't given us much information). Make...

It has...

Another easy one, thanks!

Can you post the exact error message?

Which version of SSIS are you using?

Be aware that SSIS in earlier versions is not cluster aware.

Carlo Romagnano (4/18/2014)

---

In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than...

You can copy paste the...

Too easy 😀

Have a nice Easter weekend, and don't eat too much chocolate!

Is there a value in the MemberRole element that can give an overflow for a bigint?

Oh yeah, no-one has ever died of giving columns readable names...

Pretty easy with windowing functions (if you have SQL Server 2012).

The code is quite long but that's because I have a soft spot for CTEs. The queries itself are pretty...