Forum Replies Created

Viewing 15 posts - 12,541 through 12,555 (of 49,552 total)

  • RE: Database Engine Tuning Wizard recommendation for creating stats

    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

    June 29, 2013 at 7:03 am

    #1628491

  • RE: Named Instance SQL2008R2

    Then you need to use an instance name that does not exist on that server.

    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

    June 28, 2013 at 3:13 pm

    #1628430

  • RE: Named Instance SQL2008R2

    Are you trying to upgrade the existing instance or create a new instance?

    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

    June 28, 2013 at 2:50 pm

    #1628426

  • RE: ORDER BY when inserting into table variable

    Luis Cazares (6/28/2013)

    Eugene Elutin (6/28/2013)

    We don't order INSERTS, we order SELECTS.

    Until we have identity and we want to populate it in a specific order...

    Or want to do a clustered insert...

    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

    June 28, 2013 at 10:18 am

    #1628348

  • RE: Please Help me in the query

    Table definitions, index definitions and execution plan please.

    p.s. Watch those nolocks, do you know what effect that can have on your data accuracy?

    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

    June 28, 2013 at 6:56 am

    #1628279

  • RE: Need to clarify the doubts

    With that log backup frequency, you have a data loss of up to 10 minutes, depending on the type of failure of the primary.

    If the primary fails entirely and you...

    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

    June 28, 2013 at 4:02 am

    #1628239

  • RE: Server log error

    chung_boon (6/28/2013)

    I need some guide line to check while file or which query causing the high CPU usage, i already tried certain query from internet but still unable to identified...

    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

    June 28, 2013 at 2:46 am

    #1628229

  • RE: Function inside a View

    Scalar functions are often bad for performance everywhere, view or otherwise.

    As for compiled... Like procedures it gets compiled and optimised any time it runs and there's no plan in cache...

    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

    June 27, 2013 at 11:37 pm

    #1628201

  • RE: Transaction log growing huge if DB is in simple recovery model

    girijesh.ipec (6/27/2013)

    Shink Log Files and if it occurs frequently then automate Shrink file on Daily/weekly/Monthly depending on growth of log file size.

    No, no, no! That is terrible advice.

    If 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

    June 27, 2013 at 11:46 am

    #1628075

  • RE: SQL Server 2008 R2 File Stream Sets Restricted Growth of Log File to 2TB

    2TB is the maximum possible size for a transaction log file, so unrestricted and limited to 2TB are exactly the same. It's not a side effect of file streams.

    Restricted...

    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

    June 27, 2013 at 11:44 am

    #1628073

  • RE: What's the best index?

    Indexes in most cases should be primarily there to support the WHERE clause, if they can support the WHERE and the ORDER BY, that's a bonus.

    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

    June 27, 2013 at 8:48 am

    #1628013

  • RE: ?? on shrinking transaction log

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    June 27, 2013 at 8:37 am

    #1628006

  • RE: Transaction log growing huge if DB is in simple recovery model

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

    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

    June 27, 2013 at 4:55 am

    #1627907

  • RE: Transaction log growing huge if DB is in simple recovery model

    What is growing, the log file or the data file?

    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

    June 27, 2013 at 4:52 am

    #1627905

  • RE: DB is growing if the DB is in simple recovery model.

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1468076-338-1.aspx

    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

    June 27, 2013 at 4:52 am

    #1627904

Viewing 15 posts - 12,541 through 12,555 (of 49,552 total)