Spoke to the devs and they are going to look at changing the isolation level.

We appear to have eliminated the deadlocks for now by adding some additional indexes.

I totally agree on your first comment!

I'll look into this again when I'm in the office tomorrow morning and suggest what's I think is happening.

Then you can tell me I'm...

Hi Gail,

To be honest I'm not sure. I'd have to check with the developers regarding that as to whether there is a specific reason.

I was just a bit confused because...

I ran into this issue and I believe we got around it by specifying 'MultiSubNetFailover=True' in the connection string when connecting to the listener.

Ok thanks.

I have read your article before so I'll re-visit it and go from there.

Thanks for your reply Gail.

As I said previously, I'm aware partitioning isn't for performance. I just know that there is a possibility it MAY help with queries. My main focus...

Ok no problem.

We have an old MIS system that this new DW is looking to replace. In that system, they may have a table such as Policy which they will...

I'm by no means looking to "slap" something together. I believe using partitioning will help us going forward so I'm just looking to make sure I do it in the...

I actually thought I was going to be able to get around this by making a connection to the relevant instance with the connection options, then right click and hit...

Ok I'll check out the link. Thanks.

I also found an example of creating a dynamic column list within a pivot which I think should work.

If it does I'll report back...

Thanks Craig that's really helpful.

Thanks for your sugestions Rob.

It's a mix between a framework and standards document but I'll take a look at the links you suggested and see how I go.

Have a look at the scripter object that is available in Powershell. This link has some details.

This would be a much better way of doing what you want.

Thanks Grant

Yeah you're right!

I thought datetime2 was supposed to consume less bytes than datetime depending on the precision used?

I'll check MSDN again.