Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 49,552 total)

  • RE: Locking Pages in Memory

    I don't really understand question 1. But the quote from the book's not entirely correct. If Windows is under memory pressure, first it will tell SQL (and other apps) 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

    December 30, 2015 at 2:44 am

    #1848694

  • RE: memory consumption by SQL server instance

    muzikfreakster (12/29/2015)

    Thanks Gila but you still didn't answer my question 🙂

    Um...

    GilaMonster (12/29/2015)

    Check the Total Server Memory counter in perfmon

    Perfmon's easier than a query, but if you insist on a query...

    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

    December 30, 2015 at 2:40 am

    #1848692

  • RE: Partitioned table dropped! HELP!

    steven.oates (12/29/2015)

    Therefore one of my developers scripted up the change and execuated it (without consulting with me) let in run for 7 hours and it ran out of diskspace.

    Can 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

    December 30, 2015 at 2:35 am

    #1848691

  • RE: Partitioned table dropped! HELP!

    What, exactly, is the situation and what precisely happened?

    You don't add filegroups to tables, tables are stored on filegroups, so the question doesn't make much sense.

    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

    December 29, 2015 at 3:06 pm

    #1848643

  • RE: Running SQL Profiler Trace on a specific table

    Please note: 2 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

    December 29, 2015 at 2:17 pm

    #1848634

  • RE: Partitioned table dropped! HELP!

    steven.oates (12/29/2015)

    How do I get the data from the files back in the table...

    You don't. Like any dropped object, restore your last backup as a new database, restore any log...

    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

    December 29, 2015 at 2:14 pm

    #1848632

  • RE: Index rebuilding

    You can sort in tempDB, which removes the need for the sort space in the user database, but you still need space for SQL to put down the new index,...

    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

    December 29, 2015 at 10:59 am

    #1848574

  • RE: Shrink Database

    Jeff Moden (12/29/2015)

    they don't actually know what they're talking about.

    Mostly this one, I suspect.

    And yes, you can rebuild indexes afterwards. Doing so will usually grow the data file and 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

    December 29, 2015 at 10:57 am

    #1848572

  • RE: Sql Server Service Stop And Not Run Successfully

    For your information, since you found it necessary to PM me to nag me to post further (and without a please, thank you or any courtesies at all), all 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

    December 29, 2015 at 10:57 am

    #1848571

  • RE: Shrink Database

    Not so much 'normal monitoring', more 'normal maintenance'

    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

    December 29, 2015 at 7:30 am

    #1848486

  • RE: Get Set For Speed

    Eirikur Eiriksson (12/29/2015)

    The set based code implies a hash aggregation while the loops can utilize stream aggregation as there is effectively no partitioning in each loop's execution. Makes quite 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

    December 29, 2015 at 6:58 am

    #1848474

  • RE: Are the posted questions getting worse?

    Phil Parkin (12/29/2015)

    Grant Fritchey (12/29/2015)

    Eirikur Eiriksson (12/29/2015)

    I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence...

    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

    December 29, 2015 at 6:30 am

    #1848456

  • RE: Are the posted questions getting worse?

    BrainDonor (12/29/2015)

    Eirikur Eiriksson (12/29/2015)

    I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review...

    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

    December 29, 2015 at 5:52 am

    #1848442

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/29/2015)

    I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review 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

    December 29, 2015 at 5:51 am

    #1848441

  • RE: Sql Server Service Stop And Not Run Successfully

    https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    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

    December 29, 2015 at 5:49 am

    #1848439

Viewing 15 posts - 3,916 through 3,930 (of 49,552 total)