I've not got as far into it yet as looking at the cardinality estimator but main thing that stuck out for me was online functions being considered as part of...

I've done this too. You can have up to 4 PVSCSI controllers per server so also might be a good idea to split your data over 2 controllers if possible.

If...

Hi there,

My stance is always upgrade to the latest version if you can. Maybe that's not for everyone but with enough testing there shouldn't be any problems. Also make sure...

Thanks for the reply.

I'm still not sure I'm going down this route as all my servers are virtual and not sure adding another NIC would even help.

Regards

Andrew

Hi Chris,

Yes I thinks that's what it is. There's been a recent security exercise here and looks like some of my local server rights have been removed. Even...

After some experimentation on a test server, I'm finding this works:

1. Install Patch (get failure message))
2. Reboot server
3. Install patch (right click and run as administrator)

Is there anyway of restoring and removing CDC? I was thinking you probably wont need to keep it if you are restoring to a staging environment.

Hi there,

I am going to be looking at CDC in the near future and was wondering what version of SQL Server you are using to get this error.

If anyone is interested, it was simply a case of creating an SSL cert for each server.. There is a Microsoft doc here

Regards

Andrew...

Hi Sue,

I've tried this in the past and couldn't get it to work. I didn't think that creating a proxy would enable non sysadm users to modify any job.

Regards,

Andrew

Hi there,

index_advantage = This is a calculated column. Indexes with a higher...