that is what is baffling me as well.

I am using the same server as Distributor for now, all up to date, but for some reason it is refusing to accept...

Hi Grant

I get the following: sql server replication requires the actual server name to make a connection to the server

So what I did was to create an alias in the...

I have installed the CU2 for SP3 released 2nd of March 2016 and it still doesn't work.

Surely the latest SP3 will have the same features as SP2 CU8?

Thanks Torsten

I have checked the query plans and as you say, the join seems to bring back all the products first and them filter them.

That is why I did the...

Hi Kevin

Thanks for the input. We are still busy with research before we implement any HA solution. We are ok with a little downtime, but want to decrease the time...

Hi Kevin

Dont worry, we have another company that do our server setups, I want to know what direction to send them in.

You can also just import the Excel file directly into a new table.

Right click on DB, Tasks, Import Data and select the Excel file as your source.

Perry, after reading the first article, I feel that AO will suit us better for the following reasons:

1. We can use the optimised RAID drives configured on each server, our...

Thank you for the information Perry.

Will go have a look at your article.

Thanks for the info.

We have switched off our testing environment, to save UPS up-time during load-shedding, so couldn't test it.

Will save the update for another day.

Hi Gila

When I remove the ProcessingDate join, the query barely registers a time.

Will try and find a work around for it.

ok, query is as follows

SELECT

DS.ProductId

, PD.Saturday TransactionDate

, SUM(Quantity) QTY

, SUM(Value) VAL

FROM DailySales DS

INNER JOIN ProcessingDates PD

ON DS.TransactionDate BETWEEN PD.Sunday AND PD.Saturday

WHERE DS.TransactionDate BETWEEN 'May 11 2014 12:00AM' AND 'Nov...

I looked at this option, but the max size is 2GB.

We are working with files of up to 9GB

It's an international standard for our trade, so we can't make changes to the structure.

The suggestion you made sounds near perfect though, will implement it and play around with the...

Just a last question, I can see how this will work when the XML gets transformed into 1 table.

If the record consists out of 80 odd tables, I will have...