Thanks G-Squared,

I remember reading that text in the past.

I have used for binary_checksum and MD5 in the past - really interested to see what other ppl are using.

Hi Paul,

Thanks for your response.

The structure of the fact table you've suggested is straightforward. Specifically what I am trying to picture is how the business question can be answered...

Sure, dimensions date, router and account. I just don't know how to structure the fact table in order to answer the business questions

Oops my mistake, didn't read your original post correctly!

Typically when you have a type 2 you would identify this by comparing to you current record, in your case Version =...

That's quite an interesting approach with your "Version" field Paul. I can imagine that could prove very useful.

You don't mention a "IsRowCurrent" field however, do you derive this at...

I would recommend downloading this excellent piece of freeware called XMLIFY from here[/url]

Run your data flow through this component and select the 2 fields you want to convert into XML.

Use...

I employ this with a current client and it works with no issues at all.

When the disks are presented to the active server there are no surprises.

As for configurations...

Why can you install SSIS on both nodes and store all your SSIS packages on a shared disk ideally a SAN, which both servers can access?

You could change you SQL Statement to return a value if there is no record returned in your table.

select isnull(FLAG_PRO, 'Unknown') as Flag_Arch from CARGA_ARCHIVO where FEC_1RALINEA_ARCH=?

Of course the...

Not to worry. I've managed to do the comparison using sp_srvrolepermission and comparing the permissions for each of the roles.

OK I'll give it a go shortly. Thanks

Yes it would have been much easier if however built the app using a date neutral format.

Changing the user language makes no difference I'm afraid.

Judging by this thread it seems...

Yes, you 100% correct.

So short of changing the application by putting

set language british at the start of each query what would be the permanent solution?

Paul, in response to your questions...

1.. Why do production DBAs care about tempdb usage in the Data Warehouse? Aren't these two physically separate environments? I'm sure there is a good...

I think I get it. Some people will use a loop and iterate through each number ending up with 8,000 result sets.

If you use a tally table you can return...