That's what I thought (although I thought it processed all the necessary DIMs as well).

I've just tried to process it again and it's thrown a wobbly with one of the...

I've just checked and I've got all the dimensions set to "full" and the cube itself is set to the same.

We do have measures that I haven't set to process...

Thanks Anthony.  So we can change the AG type on a server-by-server basis.

Useful to know.

There's quite a bit to learn about this.

I'm still reading up on AGs and I've now got a question I can't find an answer to.

Looking through all the documentation I can find, it looks like we can...

I haven't heard of the HeirarchyID datatype, so can you give me some pointers please?

I've also tried using a temp table (with indexing) against the full dataset but my tempdb...

Thanks Anthony

Looks like I'll have to talk to our licencing people to see what they say.

They know far more about this than I do, I just wanted to know what...

Thanks all

I'll try out the ideas and let you know when I finally get this thing to run.

Thanks Anthony

I've actually just finished a "map" of how things currently hang together and how I see them hanging together.

I'll attached the spreadsheet (I found it easier to dfraw it...

Thanks Jonathan

My smaller version of the query (using just 3 IDs) has now gone from 40 seconds to almost instant (less than 2 seconds).

I'm now doing a full against all...

• This reply was modified 4 years, 11 months ago by  richardmgreen1.

As a follow-up question on Availability Groups, do all the servers have to be on the same edition of SQL?

They will all be on SQL2016 but (assuming my plan is...

Hi Mike

Here's the table:-

USE [Lookups]
GO

/****** Object:  Table [dbo].[tbl_SCT2_Relationships]    Script Date: 27/01/2020 14:53:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_SCT2_Relationships](
[pkID] [BIGINT] NOT NULL,
[EffectiveDate] [DATE]...

• This reply was modified 4 years, 11 months ago by  richardmgreen1.

Brian - We decided to do it that way as we have a menu system (again, homegrown) to replace the normal folder structure in SSRS.

On top of that, we can...

Just my 2p-worth....

We have standard headers on all our reports and, as part of those headers, it runs a stored procerure that logs who ran the report and when.

We can...

Thanks guys

Got it sorted.

I rebooted the server after the install of the drivers and then used the code from this page:-

https://docs.microsoft.com/en-gb/archive/blogs/dbrowne/creating-a-linked-server-for-oracle-in-64bit-sql-server

(edited to match my requirements) and it now...

Thanks both

I didn't know about the TNS entry or the .ora file.

I was following the steps on this page:-

https://docs.microsoft.com/en-gb/archive/blogs/dbrowne/creating-a-linked-server-for-oracle-in-64bit-sql-server

I'll have a look at the tns entry and the...