Forum Replies Created

Viewing 15 posts - 25,966 through 25,980 (of 49,552 total)

  • RE: Different with build in shrink and use command (dbcc shrinkdatabase) to shrink database?

    If you right click -> shrink database then Enterprise Manager runs the DBCC ShrinkDatabase command.

    Be aware, shrink causes massive index fragmentation. Not something that should be scheduled or run regularly.

    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

    May 23, 2011 at 11:24 pm

    #1328835

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/23/2011)

    GilaMonster (5/23/2011)

    LutzM (5/23/2011)

    GilaMonster (5/23/2011)

    Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing...

    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

    May 23, 2011 at 3:32 pm

    #1328748

  • RE: Are the posted questions getting worse?

    LutzM (5/23/2011)

    GilaMonster (5/23/2011)

    Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give telephonic...

    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

    May 23, 2011 at 3:01 pm

    #1328731

  • RE: Performance on the query

    Ninja's_RGR'us (5/23/2011)

    Ya but I was under the impression that ssms was generating that file, so I assumed it could word on sql 2k... but obviously I was wrong ;-).

    No, it's...

    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

    May 23, 2011 at 1:57 pm

    #1328693

  • RE: How to Make this Sp a hard delete Proc?

    venu0317 (5/23/2011)

    How to make hard deletes using this procedure.

    What do you mean by a 'hard delete'? The proc already looks like it deletes the rows. What's it not...

    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

    May 23, 2011 at 1:31 pm

    #1328682

  • RE: How to Make this Sp a hard delete Proc?

    What's the question?

    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

    May 23, 2011 at 1:20 pm

    #1328674

  • RE: Performance on the query

    Ninja's_RGR'us (5/23/2011)

    never seeen that b4...

    SQL 2000 server.

    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

    May 23, 2011 at 12:38 pm

    #1328660

  • RE: Are the posted questions getting worse?

    Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give telephonic support for...

    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

    May 23, 2011 at 12:25 pm

    #1328655

  • RE: Forcing a query plan to stay in memory?

    Ninja's_RGR'us (5/23/2011)

    GilaMonster (5/23/2011)

    sqldba_icon (5/23/2011)

    So if i run this select first time, it will take 45 mins and then i run in few mins it will take only few secs reason...

    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

    May 23, 2011 at 12:18 pm

    #1328649

  • RE: Forcing a query plan to stay in memory?

    sqldba_icon (5/23/2011)

    GilaMonster (5/23/2011)

    sqldba_icon (5/23/2011)

    So if i run this select first time, it will take 45 mins and then i run in few mins it will take only few secs reason...

    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

    May 23, 2011 at 12:16 pm

    #1328646

  • RE: SQL Server 2005 performance issue.

    Grant Fritchey (5/23/2011)

    Danzz (5/23/2011)

    @ Grant Fritchey

    Thanks for the reply.

    For sure the SQL Queries are slow. How do I start over and troubleshoot.

    Tuning queries is a huge topic. If you...

    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

    May 23, 2011 at 12:02 pm

    #1328638

  • RE: Forcing a query plan to stay in memory?

    sqldba_icon (5/23/2011)

    So if i run this select first time, it will take 45 mins and then i run in few mins it will take only few secs reason is because...

    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

    May 23, 2011 at 11:59 am

    #1328637

  • RE: SQL Server R2 does not upgrade 2005 database

    Don't assume.

    The last tab on the installer (right at the bottom, below the 'install' and 'documentation' options) shows 32 bit or 64 bit.

    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

    May 23, 2011 at 11:57 am

    #1328636

  • RE: Forcing a query plan to stay in memory?

    ehdium-drivers (5/23/2011)

    Me too, I was finding that many query plans are being compiled ad hoc.

    (57% of batch requests result in compilation)

    Can you maybe start a new thread rather than...

    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

    May 23, 2011 at 10:02 am

    #1328546

  • RE: Memory

    It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the name has...

    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

    May 23, 2011 at 9:58 am

    #1328541

Viewing 15 posts - 25,966 through 25,980 (of 49,552 total)