Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 49,552 total)

  • RE: Transaction log not clearing at Checkpoint

    Check the value of log_reuse_wait_desc. It tells you why VLFs couldn't be marked reusable last time SQL tried. There are many reasons why the log might not be cleared in...

    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

    August 14, 2015 at 4:16 pm

    #1820243

  • RE: Database in Recovery

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Chris.Hubbard4U (8/14/2015)

    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried 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

    August 14, 2015 at 4:13 pm

    #1820241

  • RE: Database Mirroring and User Access

    SQLisAwE5OmE (8/14/2015)

    If both logins/users exist on both PRD/DR, then you just need to do the orphan user fix.

    Yes, but unless he fixes the root problem (the mismatched SIDs), he'll have...

    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

    August 14, 2015 at 10:14 am

    #1820120

  • RE: After Repair do I need to apply SQL Patches

    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

    August 14, 2015 at 8:10 am

    #1820065

  • RE: Metrics Table or Performance Tuning

    Probably both.

    If the data changes once a month and is queried often, then you can add a job after it's loaded to pre-aggregate into tables for later querying, then tune...

    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

    August 14, 2015 at 8:08 am

    #1820063

  • RE: Percentage of Fragmentation increased after 6 hours

    Not 'an' insert operation. Inserts multiple, probably lots of them. You can use server-side trace to watch what the apps are doing (your only option on SQL 2005), just watch...

    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

    August 14, 2015 at 4:58 am

    #1819996

  • RE: Percentage of Fragmentation increased after 6 hours

    Could be a shrink operation ran, could be inserts caused page splits. If it's the former, stop shrinking. If it's the latter, try dropping the fill factor of the 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

    August 14, 2015 at 4:46 am

    #1819990

  • RE: Shrinking a Transaction Log file (BMC Remedy environment)

    The error is "Access is denied". The SQL Server service account does not have rights to read the file in the new location. You need to give it full control...

    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

    August 14, 2015 at 4:44 am

    #1819989

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    Eric M Russell (8/13/2015)

    Also it supports statistics and non-clustered indexes...

    Table variables can have nonclustered indexes. No stats, but they can have nonclustered indexes. You just have to define them in...

    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

    August 13, 2015 at 2:20 pm

    #1819895

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/13/2015)

    GilaMonster (8/13/2015)

    Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.

    I am dealing with that with a few clients.

    Then they sit there and wonder...

    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

    August 13, 2015 at 10:29 am

    #1819792

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/13/2015)

    Yes it does. The 040orno, 041orno and 040pono porn were tossed around and spoken like they were real words. The 045porn raised a few eyebrows at...

    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

    August 13, 2015 at 9:56 am

    #1819778

  • RE: Are the posted questions getting worse?

    Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.

    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

    August 13, 2015 at 9:52 am

    #1819772

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/13/2015)

    GilaMonster (8/13/2015)

    Sean Lange (8/13/2015)

    Every table name and every column name are exactly 6 UPPER case letters.

    I'm working with one of those. Fortunately it's not case sensitive, but...

    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

    August 13, 2015 at 8:32 am

    #1819694

  • RE: Are the posted questions getting worse?

    Sean Lange (8/13/2015)

    Every table name and every column name are exactly 6 UPPER case letters.

    I'm working with one of those. Fortunately it's not case sensitive, but the tables are...

    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

    August 13, 2015 at 8:16 am

    #1819688

  • RE: Shrinking a Transaction Log file (BMC Remedy environment)

    Unnecessary. When you run the ALTER DATABASE to take it offline, specify ROLLBACK IMMMEDIATE, that'll disconnect everyone

    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

    August 13, 2015 at 7:09 am

    #1819653

Viewing 15 posts - 5,011 through 5,025 (of 49,552 total)