Forum Replies Created

Viewing 15 posts - 13,306 through 13,320 (of 49,552 total)

  • RE: SQL Server outof space question.

    haiao2000 (4/29/2013)

    GilaMonster (4/29/2013)

    Do Not delete the log file.

    Add more space and/or remove files that aren't necessary (old backups, logs, etc)

    What error do you get when you try to connect? Logging...

    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

    April 29, 2013 at 12:54 pm

    #1610963

  • RE: Database Engine vs. UI SQL Statements

    fsuoj (4/29/2013)

    their is no precompiled execution plan for that SQL string.

    Ad-hoc SQL has exactly the same plan caching and reuse as stored procedures, the matching is just done on a...

    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

    April 29, 2013 at 12:49 pm

    #1610957

  • RE: Query re-write application

    Try a plan guide, you may be able to overrule the join hint with another, though you will have to work out what the optimal join is and keep testing...

    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

    April 29, 2013 at 10:39 am

    #1610909

  • RE: Best way to do same.

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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

    April 29, 2013 at 8:53 am

    #1610847

  • RE: SQL Server outof space question.

    Was TempDB out of space as well? Was there a logon trigger?

    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

    April 29, 2013 at 8:14 am

    #1610830

  • RE: Table variable is not automatically dropped in TempDB

    Yes, it's an optimisation, SQL caches the definition and a single data page to reduce the work required to recreate it. The table variable's effectively gone, you cannot access it...

    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

    April 29, 2013 at 8:12 am

    #1610828

  • RE: SQL Server outof space question.

    Do Not delete the log file.

    Add more space and/or remove files that aren't necessary (old backups, logs, etc)

    What error do you get when you try to connect? Logging in doesn't...

    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

    April 29, 2013 at 7:58 am

    #1610819

  • RE: Index maintenance increase log size

    Take a 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

    April 29, 2013 at 7:51 am

    #1610811

  • RE: Memory setting change in existing cluster

    AWE does, max server memory is immediate.

    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

    April 29, 2013 at 7:35 am

    #1610794

  • RE: Memory setting change in existing cluster

    You change that through SQL, either with SSMS right click the server, properties, memory or using sp_configure

    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

    April 29, 2013 at 7:14 am

    #1610777

  • RE: SQL BACKUP JOB Failure

    Please note: 4 year old thread.

    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

    April 29, 2013 at 6:36 am

    #1610767

  • RE: DBCC Shrinkfile issues

    The presence or absence of a log backup will make absolutely no difference in this case as you're shrinking a data file, not a log file.

    LOB data causes shrinks 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

    April 29, 2013 at 6:35 am

    #1610765

  • RE: Index maintenance increase log size

    S_Kumar_S (4/29/2013)

    So I am left with option 2 only. Here also, the log size takes 2 hours to grow to 160 GB. So when log backups are happening every 20...

    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

    April 29, 2013 at 6:33 am

    #1610764

  • RE: Truncate Log Script

    I suggest the following for that script:

    Ctrl-A, Del.

    Then read over this for an idea on how to manage your transaction logs properly.

    Managing Transaction Logs[/url]

    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

    April 29, 2013 at 6:29 am

    #1610761

  • RE: Rebuild or DBREINDEX

    More TempDB space, more resources, longer duration. It still takes locks, just short-lived ones

    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

    April 29, 2013 at 3:08 am

    #1610708

Viewing 15 posts - 13,306 through 13,320 (of 49,552 total)