Viewing 15 posts - 1 through 15 (of 17 total)
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...
October 22, 2019 at 9:28 am
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...
October 22, 2019 at 9:10 am
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...
October 22, 2019 at 8:59 am
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
May 9, 2019 at 9:30 am
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...
November 21, 2018 at 2:14 am
November 20, 2018 at 2:07 am
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)
November 19, 2018 at 5:59 am
April 26, 2018 at 1:56 am
April 24, 2018 at 8:15 am
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.
February 14, 2018 at 3:34 am
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.
February 13, 2018 at 5:31 am
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...
July 21, 2017 at 1:41 am
January 12, 2017 at 5:25 am
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
December 6, 2016 at 2:21 am
SQL Galaxy (9/23/2016)
could Pls. explain the following outputs
index_advantage = 7983.73805718724
user_seeks = 116
avg_total_user_cost = 92.4947293095018
avg_user_impact = 74.41
Hi there,
index_advantage = This is a calculated column. Indexes with a higher...
September 23, 2016 at 2:21 am
Viewing 15 posts - 1 through 15 (of 17 total)