Forum Replies Created

Viewing 15 posts - 16,696 through 16,710 (of 49,552 total)

  • RE: Max Degree of parallellism

    Tell them that's the biggest load of hogswash you've heard and they should kindly update their 'best practices' from ones used 10 years ago. 🙂

    Seriously though, no, that's not 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 11, 2012 at 4:03 am

    #1536104

  • RE: Wait Stats Investigation

    We'd have easily written 1200 pages, but the deadline was against us. 🙂

    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 11, 2012 at 3:59 am

    #1536097

  • RE: Memory Leak SQL 2008 R2 64 bit?

    Did you read the article that Opc linked?

    opc.three (9/11/2012)

    Here is a good primer on the debate and one of many articles and my own experience that helped shape my opinion:...

    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 11, 2012 at 3:42 am

    #1536089

  • RE: Wait Stats Investigation

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Start with chapter 1.

    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 11, 2012 at 2:52 am

    #1536060

  • RE: log_reuse_wait_desc column says LOG_BACKUP - what should i do ?

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

    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 11, 2012 at 2:50 am

    #1536056

  • RE: How do I fix Damaged allocation pages

    Perry Whittle (9/11/2012)

    Another thing i would do with some urgency is to audit all user databases and find which ones are set to simple recovery and then query the business...

    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 11, 2012 at 2:49 am

    #1536054

  • RE: Memory Leak SQL 2008 R2 64 bit?

    ananda.murugesan (9/11/2012)

    Performance Tap in task manager why 7.5 GB consuming physical memory using after restarted SQL services, it was totaly reduced and now comsuming 4.55 GB only...thats what I have...

    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 11, 2012 at 2:48 am

    #1536052

  • RE: T-SQL help

    Insert into Table1 (<column list>)

    Select <columns> from Table2

    WHERE <primary key column> NOT IN (select <primary key column> FROM Table1)

    or

    Insert into Table1 (<column list>)

    Select <columns> from Table2

    EXCEPT

    Select <columns> from Table1

    Roughly.

    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 10, 2012 at 5:10 pm

    #1535958

  • RE: How to insert empty row

    Blank for those data types would be null.

    That said, if you're planning the 'pattern' of inserting a blank row then updating it to actual values, please reconsider. It can cause...

    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 10, 2012 at 5:04 pm

    #1535955

  • RE: Execution Plans & Table Locks

    Not that I can think of. Locking can get very complex

    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 10, 2012 at 2:47 pm

    #1535926

  • RE: How do I fix Damaged allocation pages

    jdbrown239 (9/10/2012)

    I will try restoring the data from the backup after copying the current table to a temp table.

    If there's corruption in the table, trying to copy it will...

    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 10, 2012 at 2:45 pm

    #1535925

  • RE: 2008 indexed view r2 standard edition

    It's allowed, but you'll have to add the NoExpand hint to any query that you want to use the indexed view

    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 10, 2012 at 2:44 pm

    #1535923

  • RE: SQL 2012 - Trace flag 3604 turning on and off, sp_server_diagnostic

    As for the first, 3rd party monitoring tool running?

    As for the second, clustered instance?

    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 10, 2012 at 2:06 pm

    #1535913

  • RE: Would a smaller number of VLFs in the log speed up the redo phase of recovery of a mirror snapshot?

    Marios Philippopoulos (9/10/2012)

    Once I switch the db to single-user mode and take a log backup, there should be no active-log portion in any of the files.

    There is always an active...

    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 10, 2012 at 1:32 pm

    #1535900

  • RE: Memory Leak SQL 2008 R2 64 bit?

    opc.three (9/10/2012)

    I think the OP is saying memory used by sqlservr.exe per Task Manager (count on Processes Tab should include buffer pool for x64 SQL) is only 124MB but Task...

    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 10, 2012 at 1:21 pm

    #1535896

Viewing 15 posts - 16,696 through 16,710 (of 49,552 total)