Forum Replies Created

Viewing 15 posts - 14,146 through 14,160 (of 49,552 total)

  • RE: delete database

    DROP DATABASE <database name>

    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 26, 2013 at 6:43 am

    #1591170

  • RE: Sql server 2008 R2 , Database growth setting

    Then do a once-off shrink, leave enough free space in the database for normal operation, and rebuild all your indexes.

    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 26, 2013 at 6:27 am

    #1591162

  • RE: Sql server 2008 R2 , Database growth setting

    Why do you want to remove the free space?

    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 26, 2013 at 6:11 am

    #1591157

  • RE: Fragmentation

    runal_jagtap (2/26/2013)

    Thanks Gail 🙂

    But On weekly basis the Log gets Full & then application stops running or the DB runs very slow ... how to tackle this now...

    Please assist what...

    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 26, 2013 at 5:31 am

    #1591140

  • RE: How to shrink TempDb

    mpdillon (2/26/2013)

    I am still a bit lost so let me paraphrase. A CTE never writes data to the TempDb. But in this instance since the TempDb grows from 8MB 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 26, 2013 at 5:30 am

    #1591139

  • RE: Fragmentation

    Don't truncate your log (not that you can in SQL 2008).

    Please read through this - 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

    February 26, 2013 at 5:08 am

    #1591130

  • RE: Log File full / Database Down

    Please read through this - Managing Transaction Logs[/url] and - http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Don't just shrink or change recovery models without analysing and knowing the effects of the actions.

    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 26, 2013 at 3:48 am

    #1591101

  • RE: Partitioned Tables

    munnaonly (2/25/2013)

    Yes, i referred the article, but i haven't see difference, is any other setting there ?

    Errr... the entire first section of that article explains why partitioning does not get...

    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 26, 2013 at 3:11 am

    #1591087

  • RE: How to shrink TempDb

    ScottPletcher (2/25/2013)

    GilaMonster (2/25/2013)

    ScottPletcher (2/25/2013)

    GilaMonster (2/25/2013)

    CTEs don't store results

    Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk 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

    February 26, 2013 at 3:10 am

    #1591086

  • RE: How to shrink TempDb

    ScottPletcher (2/25/2013)

    GilaMonster (2/25/2013)

    CTEs don't store results

    Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk then, presumably 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 25, 2013 at 3:48 pm

    #1590967

  • RE: Partitioning does not improves queries

    https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

    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 25, 2013 at 3:44 pm

    #1590963

  • RE: Looking to select last time tables were queried

    Jason-299789 (2/25/2013)

    wouldn't the Database level Audit be enough, as this seems to handle events for Select, Insert, Update, and Delete Actions?

    That should work too, might have to aggregate, 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

    February 25, 2013 at 8:41 am

    #1590831

  • RE: Looking to select last time tables were queried

    Sean Lange (2/25/2013)

    That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are looking for.

    A 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 25, 2013 at 8:09 am

    #1590823

  • RE: Looking to select last time tables were queried

    This kind of thing is incredibly difficult to do.

    Probably best thing you can do is set up an extended events session for Object accessed (I think it's in the 2008...

    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 25, 2013 at 8:07 am

    #1590821

  • RE: How to shrink TempDb

    mpdillon (2/25/2013)

    I completely agree with you. Whatever is being created in the TempDb is not being reused between when the query runs the second, third, fourth, etc times. I 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

    February 25, 2013 at 5:26 am

    #1590765

Viewing 15 posts - 14,146 through 14,160 (of 49,552 total)