Forum Replies Created

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

  • RE: Execution plan showing Table scan though Index is present

    The table scan (rather than index seek) is probably because the index is not covering and the query returns too large a percentage of the table for the combination 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

    September 19, 2010 at 11:48 pm

    #1223819

  • RE: Is this a 2005 bug?

    phil.layzell (9/19/2010)

    Is this a bug in 2005, or am I programming by coincidence?

    No. Yes. (in that order)

    SQL is under absolutely no obligations regarding the order that it evaluates predicates...

    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

    September 19, 2010 at 11:32 pm

    #1223815

  • RE: Help with PIVOT?

    No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic989110-392-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

    September 19, 2010 at 11:28 pm

    #1223812

  • RE: Process ID %dis not a valid process ID. Choose a number between 1 and 32817.

    Is spid 420 a valid sessionID? If you query sys.processes, is it 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

    September 19, 2010 at 11:24 pm

    #1223810

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)

    The log_reuse_wait_desc is "LOG_BACKUP" when selecting on the appropriate database_id.

    Ok.... Is it still the same after doing a log backup? If so, what's the script you're using to do...

    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

    September 19, 2010 at 11:19 pm

    #1223806

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/19/2010)

    GilaMonster (9/19/2010)

    Is my irritation with this guy justifiable, or a product of a mostly wasted day? (well, until his last post that is)

    http://www.sqlservercentral.com/Forums/Topic988907-391-1.aspx

    Maybe it's just me but I...

    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

    September 19, 2010 at 2:50 pm

    #1223707

  • RE: Are the posted questions getting worse?

    Is my irritation with this guy justifiable, or a product of a mostly wasted day? (well, until his last post that is)

    http://www.sqlservercentral.com/Forums/Topic988907-391-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

    September 19, 2010 at 12:09 pm

    #1223684

  • RE: Shouldn't the trans log backup be truncating my log file?

    The sys.databases view is a server-wide view that contains one row for each database on the server. It returns the same no matter what database context you are in.

    That list...

    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

    September 19, 2010 at 12:06 pm

    #1223683

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)

    Those results were from the same db. Here is the statement:

    use databaseName (same as LogInfo)

    select log_reuse_wait_desc from sys.databases

    sys.databases returns 1 row for each database on 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

    September 19, 2010 at 12:00 pm

    #1223680

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)

    So for optimal performance, do you recommend hourly log backups?

    Log backup frequency has nothing to do with performance. It has to do with data loss policies 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

    September 19, 2010 at 11:59 am

    #1223679

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)

    GilaMonster (9/19/2010)

    Looks like something's keeping the log active.

    What's the value of log_reuse_wait_desc in sys.databases for this database?

    log_reuse_wait_desc

    DATABASE_SNAPSHOT_CREATION

    NOTHING

    LOG_BACKUP

    DATABASE_SNAPSHOT_CREATION

    NOTHING

    LOG_BACKUP

    LOG_BACKUP

    What's the value for this database? (The one that you did the LogInfo...

    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

    September 19, 2010 at 11:53 am

    #1223676

  • RE: How to prevent our database to access any person

    kumar.sachu08 (9/19/2010)

    That's why i am saying microsoft should be work for the same. Provide password facility on backup file, by which no one can execute any command when i set...

    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

    September 19, 2010 at 11:47 am

    #1223674

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)

    If shrinking the log is s bad thing, then how do you recommend keeping the transaction log from hitting 100gb's and higher? I just want to keep 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

    September 19, 2010 at 11:42 am

    #1223672

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/19/2010)

    GilaMonster (9/19/2010)

    Steve Jones - Editor (9/19/2010)

    Gail will be harder since she's in South Africa, and a lot "sends" don't quite get there. I'll have to work with RG...

    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

    September 19, 2010 at 11:40 am

    #1223669

  • RE: Shouldn't the trans log backup be truncating my log file?

    Looks like something's keeping the log active.

    What's the value of log_reuse_wait_desc in sys.databases for this database?

    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

    September 19, 2010 at 11:39 am

    #1223668

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