Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 49,552 total)

  • RE: Tranlog in simple recovery mode

    You've got an active transaction. A session somewhere has run a BEGIN TRANSACTION and has not either committed or rolled the transaction back.

    Commit or roll back the open transaction, then...

    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

    December 31, 2014 at 1:29 am

    #1767135

  • RE: Deadlocks, wiats, deadlocks

    Igor Micev (12/30/2014)

    GilaMonster (12/29/2014)

    Have a read through this: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    Hi Gail,

    I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't 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

    December 30, 2014 at 10:35 am

    #1767040

  • RE: Update statement times out on a small table

    goussarova (12/30/2014)

    Hi Gail,

    No, I have no proof of page locking.

    I have not considered read committed snapshot or snapshot isolation as I never used them before.

    I read about snapshot isolation this...

    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

    December 30, 2014 at 10:27 am

    #1767038

  • RE: Copy Database vs Backup/Restore Database

    Backup/restore - backup the database to a file. Restore from file.

    Copy database wizard - run object creation scripts on destination and copy data one table at a time.

    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

    December 30, 2014 at 5:08 am

    #1766968

  • RE: date in select statement

    SELECT * FROM TableName WHERE DateTimeColumn = '2014-12-28 08:52:02.920'

    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

    December 30, 2014 at 2:51 am

    #1766951

  • RE: Establishing a mirror - between 2005 and 2008 R2 (standard) - error 1478

    994388426 (12/30/2014)

    1.For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.

    Not entirely true. Mirroring up-version...

    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

    December 30, 2014 at 2:46 am

    #1766948

  • RE: Establishing a mirror - between 2005 and 2008 R2 (standard) - error 1478

    matt.newman (12/12/2014)

    The only thing I could attempt is breaking log shipping, which I would prefer to avoid. Or, kill maintenance for a night to slow all transactions to speed 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

    December 30, 2014 at 2:45 am

    #1766947

  • RE: how to count data

    The same way as in this thread of yours http://www.sqlservercentral.com/Forums/Topic1646925-149-1.aspx, you can just omit the LEFT function since you're grouping by the entire column

    Please don't post multiple threads for 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

    December 30, 2014 at 2:29 am

    #1766942

  • RE: DBCC CheckDB jobs failed

    Not enough information there. The CheckDB output would have been written to the error log. Look there.

    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

    December 30, 2014 at 1:41 am

    #1766938

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (12/29/2014)

    They've given me my own exclusive space to play with. I checked and rechecked to make sure of that, because I was worried I might bull-in-a-china-shop it, and break...

    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

    December 30, 2014 at 1:39 am

    #1766936

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (12/29/2014)

    Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that to restore, all...

    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

    December 30, 2014 at 1:35 am

    #1766934

  • RE: Update statement times out on a small table

    goussarova (12/29/2014)

    As Gail Shaw mentioned, since the sql will always place an exclusive lock, and since every machine updates its own record, may be I should use row locking instead...

    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

    December 30, 2014 at 1:30 am

    #1766933

  • RE: IF Log Cache Hit Ratio is 95.2810180276% reaches this much what should we do??

    Why do you think you need to do anything?

    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

    December 30, 2014 at 1:29 am

    #1766932

  • RE: Display Order due to NonClustered Index

    No ORDER BY, no guarantee of order. End of Story

    If you need a particular order, put an ORDER BY on your query.

    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

    December 30, 2014 at 1:28 am

    #1766931

  • RE: SQL Server 2014 Checklist for Performance

    Uwe Ricken (12/29/2014)

    SELECT, INSERT, UPDATE, DELETE are definitely not always single threaded. They can all run in parallel when the optimiser decides that the plan is expensive enough (compared with...

    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

    December 29, 2014 at 7:49 am

    #1766783

Viewing 15 posts - 6,901 through 6,915 (of 49,552 total)