Forum Replies Created

Viewing 15 posts - 16,261 through 16,275 (of 49,552 total)

  • RE: Query Memory Usage

    Nothing to do with the buffer pool. That's the workspace memory grant for the query to do operations that themselves require memory. Hashes, sorts, exchanges, that sort of thing.

    As 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

    October 7, 2012 at 3:32 am

    #1546482

  • RE: Logged into a SQL Server and not active state

    As in remote desktop connections or sleeping SQL connections?

    How many are you talking about?

    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

    October 7, 2012 at 3:27 am

    #1546481

  • RE: count(*) taking forever... emergency

    For the nolock, see - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    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

    October 7, 2012 at 3:16 am

    #1546480

  • RE: Certifications for beginner

    Absolutely. See the link I posted.

    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

    October 6, 2012 at 10:17 am

    #1546432

  • RE: Certifications for beginner

    This should have everything you need

    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

    There's no developer/DBA distinction for the 2012 exams. There's just the data platform certification which includes dev and DBA (and a bit of BI) aspects

    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

    October 6, 2012 at 9:49 am

    #1546427

  • RE: Help reading Deadlock graph

    Firstly, if you want a readable deadlock graph, turn traceflag 1204 off and turn traceflag 1222 on (or read the deadlock graph from the system health extended events session)

    The deadlock...

    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

    October 6, 2012 at 7:11 am

    #1546409

  • RE: sys.dm_os_sys_info vs. dm_os_buffer_descriptors discrepancy

    The buffer pool does not just consist of the data cache. There are several other caches that form part of the buffer pool, and space for workspace memory grants 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

    October 6, 2012 at 7:08 am

    #1546408

  • RE: count(*) taking forever... emergency

    Chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ (Blocking)

    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

    October 6, 2012 at 3:05 am

    #1546392

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (10/5/2012)

    Brandie Tarvin (10/5/2012)

    Hey, all. My publisher is offering free swag (including a Kindle Fire) in our 1st year anniversary blog hop. Only 2 more days to enter. 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

    October 5, 2012 at 2:31 pm

    #1546314

  • RE: FileGroup restore

    You need to restore all log backups from the oldest of the filgroup backups you restored right up to the latest, so that you can bring the entire DB 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

    October 5, 2012 at 2:29 pm

    #1546313

  • RE: Microsoft Certified Master

    Paul Brewer (10/5/2012)

    I won't be trying anything wacky. From reading what others have said, the best approach seems to be to make a first pass through the entire exam answering...

    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

    October 5, 2012 at 12:51 pm

    #1546285

  • RE: Question Regarding Backup Policy

    With just a DR plan, how do you restore the DB to 10pm yesterday, right before someone dropped a table?

    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

    October 5, 2012 at 12:44 pm

    #1546280

  • RE: Microsoft Certified Master

    If all you need is a 'is it WITH or SET' and 'are the brackets before the commas or after?', it's fine. There's no where near enough time to be...

    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

    October 5, 2012 at 11:48 am

    #1546249

  • RE: Microsoft Certified Master

    BoL's there, it really doesn't help much though.

    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

    October 5, 2012 at 11:22 am

    #1546227

  • RE: Temp table for Performance Impact

    There's only a difference in logging in bulk-logged or simple recovery models.

    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

    October 5, 2012 at 9:00 am

    #1546150

Viewing 15 posts - 16,261 through 16,275 (of 49,552 total)