Forum Replies Created

Viewing 15 posts - 9,976 through 9,990 (of 49,552 total)

  • RE: sudden performance degradation

    Guessing without metrics.

    Try updating stats on all tables involved in the process with full scan.

    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

    February 19, 2014 at 1:54 am

    #1690170

  • RE: Big transaction log file

    cygne17_2 77208 (2/18/2014)

    Which scenario do you recommend?

    1- Backup the database, backup the transaction log to a new disk, shrink the transaction log file, schedule transaction log backup each hour.

    2- Backup...

    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

    February 19, 2014 at 12:40 am

    #1690164

  • RE: Page Life Expectancy is too low

    Chapter 4 - http://www.red-gate.com/community/books/accidental-dba. All about memory, memory contention.

    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

    February 19, 2014 at 12:36 am

    #1690163

  • RE: Number of Records Affected

    jayoub (2/6/2014)

    The rollback tran works perfectly for me. Thank you very much.

    Just bear in mind that performs the operation and then undoes it. If a lot of...

    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

    February 18, 2014 at 7:58 am

    #1689921

  • RE: Finding contents of logical file

    Objects aren't defined on files, they're defined on filegroups. If you have two files in a filegroup, all objects on that filegroup will be spread across both files.

    If you want...

    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

    February 18, 2014 at 7:55 am

    #1689918

  • RE: Apply Unique constraints on existing database

    TomThomson (2/18/2014)

    What happens if that nullable column containts the string '12345' or '42 ' or anything else which will test equal to the result of casting some integer 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

    February 18, 2014 at 7:00 am

    #1689884

  • RE: Apply Unique constraints on existing database

    TomThomson (2/18/2014)

    GilaMonster (2/18/2014)

    Why clustered? This isn't typically where you would put the clustered index.

    not clustered isn't a sensible option - a view has to have a clustered unique index before...

    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

    February 18, 2014 at 5:37 am

    #1689847

  • RE: Apply Unique constraints on existing database

    Other than what I just said one message back, not really. Too open ended, not enough information. Test under expected volumes and see.

    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

    February 18, 2014 at 5:22 am

    #1689843

  • RE: Apply Unique constraints on existing database

    Yup, that's it. Should be less overhead than an indexed view.

    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

    February 18, 2014 at 5:15 am

    #1689840

  • RE: Sybase ASE 15 SQL Query

    This site is for Microsoft SQL Server, not any generic SQL database. Maybe try http://www.dbforums.com, they should have a sybase sections

    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

    February 18, 2014 at 4:49 am

    #1689829

  • RE: Apply Unique constraints on existing database

    Why a view, rather than just an indexed computed column? It'll work, but....

    Do you not have a column that is already unique in the table, eg the primary key columns?

    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

    February 18, 2014 at 4:32 am

    #1689820

  • RE: Backups failing - SQL Server 2008 R2

    So then you're going to need to dig into the backup app's logs and find the detailed messages. The message in the SQL error log is just a 'something happened'...

    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

    February 18, 2014 at 4:29 am

    #1689816

  • RE: Apply Unique constraints on existing database

    I already did.

    GilaMonster (2/17/2014)

    For 2005, define a computed column on ISNULL(<column that you want to be unique>,<the primary key column of the table>) and put a unique index on that...

    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

    February 18, 2014 at 4:26 am

    #1689813

  • RE: IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()

    It's a corrupt database. Ask your DBA to run a database consistency check.

    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

    February 18, 2014 at 4:25 am

    #1689812

  • RE: Apply Unique constraints on existing database

    Why clustered? This isn't typically where you would put the clustered index.

    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

    February 18, 2014 at 4:14 am

    #1689806

Viewing 15 posts - 9,976 through 9,990 (of 49,552 total)