Forum Replies Created

Viewing 15 posts - 16 through 30 (of 49,552 total)

  • RE: Claculated field in Where clause

    Just turns it into a different performance problem. One that's always bad, rather than bad depending on parameter passed, because the rows are estimated for <column> >= NULL, which always...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2019 at 11:25 am

    #2018970

  • RE: Database refresh from Production DB to Test DB in Sql server 2014

    You need the certificate to be installed in master on the test instance to be able to restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2019 at 10:43 pm

    #2018802

  • RE: Database refresh from Production DB to Test DB in Sql server 2014

    Yes, you do want the logins from prod, or you'll have mismatched logins every single time that you do the restore to dev. That's what creating the logins from prod...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2019 at 2:35 pm

    #2018799

  • RE: Database refresh from Production DB to Test DB in Sql server 2014

    You do step 2 once. Not every time.
    And you generate the login script from prod, not test. You want the logins on test to have the same sids...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2019 at 12:56 pm

    #2018794

  • RE: memory setting in sql server

    What do you mean 'it doesn't reflect'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2019 at 4:44 am

    #2018786

  • RE: Can NULLs Exist in the Columns of a Non-Clustered Index?

    I chatted with someone from SolarWinds. Please contact their customer support people and open a request to get this help file corrected

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2019 at 4:35 am

    #2018785

  • RE: Can NULLs Exist in the Columns of a Non-Clustered Index?

    Gail Wanabee - Wednesday, January 9, 2019 4:39 PM

    I believe you are correct. However, I commented out this line of code: --CREATE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 2:01 am

    #2018491

  • RE: Can NULLs Exist in the Columns of a Non-Clustered Index?

    Gail Wanabee - Wednesday, January 9, 2019 2:42 PM

    A fairly credible source (SolarWinds, DPA help function) had this advice for determining the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 1:57 am

    #2018490

  • RE: Automatically inserting foreign keys

    You could probably do it with a trigger, though will have to be complex and on both tables, and I don't know how you plan to have it automatically figure...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 1:55 am

    #2018489

  • RE: How to update table by using CTE Store Procedure

    Asked and answered in another thread. https://www.sqlservercentral.com/Forums/2015957/How-to-create-Update-Store-Procedure-in-sql-between-two-table
    Please in future stick to a single thread for a question

    If you  format your code well, these missing brackets...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 1:54 am

    #2018488

  • RE: How to create Update Store Procedure in sql between two table ?

    You're missing )) (two close brackets) after the END, just before the FROM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 1:49 am

    #2018487

  • RE: Claculated field in Where clause

    1974lg - Wednesday, January 9, 2019 8:48 PM

    GilaMonster - Wednesday, January 9, 2019 12:45 PM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2019 at 1:33 am

    #2018485

  • RE: Are cl and clst system indexs?

    You do not. It's a system table, you can't even see it.
    And note, it's not one index, your query aggregated 65 indexes into 2.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2019 at 1:06 pm

    #2018456

  • RE: Transaction log filling up issue.

    Toby Harman - Tuesday, January 8, 2019 10:24 PM

    You might want to try and persuade either CommVault OR the local backups to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2019 at 1:03 pm

    #2018455

  • RE: Claculated field in Where clause

    The problem with optional parameters like that is that they're a performance problem. Erratic performance, varying usually between moderately bad and very bad.
    https://sqlinthewild.co.za/index.php/2018/03/13/revisiting-catch-all-queries/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2019 at 12:45 pm

    #2018452

Viewing 15 posts - 16 through 30 (of 49,552 total)