Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 49,552 total)

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Luis Cazares (11/19/2014)

    I know that ApexSQL Refactor does that, but I'm sure that other tools can do the work as well.

    Latest version of SQL prompt can do that too....

    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

    November 20, 2014 at 2:11 pm

    #1759971

  • RE: SQL DBA knowing user passwords

    NJDave (11/20/2014)

    Should a SQL DBA know users passwords when using SQL Server authentication?

    Absolutely not.

    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

    November 20, 2014 at 8:49 am

    #1759871

  • RE: Left Join Perfomance

    There's 5 posts on my blog on the subject if you want the full detail.

    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

    November 20, 2014 at 7:17 am

    #1759828

  • RE: Left Join Perfomance

    WHERE EXISTS, not IF NOT EXISTS

    Very, very, very slightly more efficient.

    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

    November 20, 2014 at 6:37 am

    #1759817

  • RE: Backing up a production SQL Database

    rrn 62873 (11/20/2014)

    Will DBCC CHECKDB ever fail a job step?

    Yes.

    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

    November 20, 2014 at 5:57 am

    #1759804

  • RE: Policy Based Management

    That sounds more like a server-scoped DDL trigger.

    PBM is for enforcing policies (like ensure no databases are named in such a way, ensure all databases are in full recovery, etc)....

    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

    November 20, 2014 at 5:41 am

    #1759796

  • RE: Backing up a production SQL Database

    rrn 62873 (11/20/2014)

    Using Ola's solution, I have now set up a solution where the production database gets maintained (DBCC and index rebuild/defrag) every saturday, differential backups every four hours and...

    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

    November 20, 2014 at 5:38 am

    #1759795

  • RE: error log on changing the compatibility mode from 80 to 90 in SQL Server 2005

    You test your application against a test database that's already been upgraded, you identify any issues and you fix them. Once the tests run clean, then you update the compatibility...

    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

    November 20, 2014 at 5:34 am

    #1759792

  • RE: error log on changing the compatibility mode from 80 to 90 in SQL Server 2005

    By testing before you make the change.

    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

    November 20, 2014 at 5:07 am

    #1759784

  • RE: Left Join Perfomance

    To be honest, performance is irrelevant in this case.

    If you need all the rows from a large table and matching rows from a small table, then LargeTable LEFT OUTER JOIN...

    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

    November 20, 2014 at 5:03 am

    #1759783

  • RE: error log on changing the compatibility mode from 80 to 90 in SQL Server 2005

    It won't generate anything and there are no checks done when you change the compat level.

    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

    November 20, 2014 at 2:16 am

    #1759753

  • RE: Achievement Unlocked: Balance 0

    I've been sitting with negative leave days available since July (about -0.5 at this point). No one in management is complaining, no pointed hints that I need to work more....

    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

    November 20, 2014 at 2:01 am

    #1759746

  • RE: alter table datatype giving error date to bit

    Koen Verbeeck (11/20/2014)

    GilaMonster (11/20/2014)

    Your table is too wide. The fixed length columns in a table (data types other than varchar/nvarchar) cannot exceed 8060 bytes total. Your table is so large...

    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

    November 20, 2014 at 1:36 am

    #1759741

  • RE: Need to check which query is taking longer

    The DMV above just shows averages of what's in the plan cache, not exact executions of each query. That may be good enough, it may not be.

    Have a read through...

    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

    November 20, 2014 at 1:35 am

    #1759739

  • RE: Best Practices

    ramana3327 (11/19/2014)

    That is not related to parameter sniffing.

    Why because we are passing 3 input parameters. Those are default parameters. We are not changing either in SP or Report also.

    Just tested...

    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

    November 20, 2014 at 1:25 am

    #1759736

Viewing 15 posts - 7,231 through 7,245 (of 49,552 total)