Forum Replies Created

Viewing 15 posts - 23,311 through 23,325 (of 49,552 total)

  • RE: Where are all the MVBs?

    Jeff Moden (9/24/2011)

    To put my own slant on what she said, I believe that a lot of excellent DBA's have simply tired of the fight with stupid people (as 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

    September 24, 2011 at 3:25 pm

    #1386138

  • RE: Index Reorg Causing Transaction log to fill up

    Patti Johnson (9/24/2011)

    I thought I read that an index reorg is considered one long transaction.

    Rebuilds are a single transaction, fully logged in full recovery, minimally logged in bulk-logged...

    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 24, 2011 at 11:36 am

    #1386121

  • RE: Index Reorg Causing Transaction log to fill up

    Bulk logged recovery won't help. Index reorg is a full-logged operation, always. (it's rebuild that is minimally logged in bulk-logged and simple). Besides, mirroring requires full recovery.

    You can increase 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 24, 2011 at 10:38 am

    #1386114

  • RE: What is the difference between 2008 R2 Express and 2008 R2 RTM?

    I haven't seen an iso, but it's available as an exe (or zip maybe) from the Microsoft site. A google or bing search will find it easily.

    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 24, 2011 at 9:35 am

    #1386107

  • RE: Where are all the MVBs?

    I suspect that they all were driven insane by bureaucracy and red tape and retired to desert islands.

    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 24, 2011 at 8:37 am

    #1386103

  • RE: Why DML operations are not supported in functions?

    As I said, if a function doesn't have side effect (DML orDDL), the optimiser is free to run it as many times as makes sense for a query plan. If...

    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 24, 2011 at 8:36 am

    #1386102

  • RE: Why DML operations are not supported in functions?

    Because a function may not have side effects (change the permanent database structure).

    If a function doesn't have side effect, the optimiser is free to run it as many 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

    September 24, 2011 at 3:14 am

    #1386093

  • RE: Trying to convert from 2000 to 2005

    Please post new questions in a new thread. Thank 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

    September 23, 2011 at 12:43 pm

    #1385989

  • RE: Index usage after UNION operator

    There's an implicit conversion that's forcing the scan. You'll probably find that the data types of attributevalue is not the same in both tables. SQL has to convert 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 23, 2011 at 11:56 am

    #1385960

  • RE: Device activation error. The physical file name

    GilaMonster (9/23/2011)

    Post the attach statement, post any messages in the SQL error log after the attach.

    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 23, 2011 at 11:54 am

    #1385958

  • RE: Index usage after UNION operator

    Post the exec plan please

    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 23, 2011 at 11:40 am

    #1385952

  • RE: Are the posted questions getting worse?

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

    GilaMonster (9/22/2011)

    EXEC TotalChangeOfSubject

    SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

    Chapter 8: "The how and why of Page Restores",...

    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 23, 2011 at 11:29 am

    #1385946

  • RE: how to find Ram memory occupied by sql server

    Gianluca Sartori (9/23/2011)

    I always feel safer when I set up a SQL_SERVICE user on my laptop with no special permissions. Maybe I'm paranoid, but that's just how I feel. -)

    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 23, 2011 at 11:23 am

    #1385941

  • RE: how to find Ram memory occupied by sql server

    SQLRNNR (9/23/2011)

    GilaMonster (9/23/2011)

    I could plug Jonathan Kehayias's upcoming book that I know covers it (in chapter 4). but it won't be out for a couple weeks...

    Title? That is 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

    September 23, 2011 at 11:13 am

    #1385931

  • RE: how to find Ram memory occupied by sql server

    Gianluca Sartori (9/23/2011)

    So, why does TaskManager display wrong info for sqlservr.exe? Is there a particular reason?

    Yes, it's not a bug (not really)

    I could plug Jonathan Kehayias's upcoming book that 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 23, 2011 at 10:42 am

    #1385896

Viewing 15 posts - 23,311 through 23,325 (of 49,552 total)