Forum Replies Created

Viewing 15 posts - 1 through 15 (of 17 total)

  • Reply To: SQL Upgrade (From SQL 2014) Suggestions

    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...

  • Reply To: Disk subsystem issue with vmware

    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...

  • Reply To: SQL Upgrade (From SQL 2014) Suggestions

    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...

  • Reply To: Availability groups and dedicated NICs

    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

  • RE: SP2 CU4

    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...

  • RE: SP2 CU4

    Steve Jones - SSC Editor - Monday, November 19, 2018 9:38 AM

    What if you ran the first time as admin? Or did...

  • RE: SP2 CU4

    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)

  • RE: Auditing

    Sue_H - Wednesday, April 25, 2018 3:45 PM

    AndrewL65 - Tuesday, April 24, 2018 4:35 AM

  • RE: Auditing

    Jeff Moden - Tuesday, April 24, 2018 8:09 AM

    I've no experience in such auditing software but can only imagine how much extra...

  • RE: Restore a Database with CDC Enabled

    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.

  • RE: Restore a Database with CDC Enabled

    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.

  • RE: TLS and AlwaysOn

    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...

  • RE: SQL Agent Job Manager

    Sue_H - Tuesday, December 6, 2016 5:32 AM

    If you need them to manage and edit any and all jobs then the only option...

  • RE: SQL Agent Job Manager

    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

  • RE: Missing Index Script with Create Statement

    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...

Viewing 15 posts - 1 through 15 (of 17 total)