Forum Replies Created

Viewing 15 posts - 38,236 through 38,250 (of 49,552 total)

  • RE: Bookmark Lookup Options...

    A bookmark lookup is done when SQL uses an index for a query but that index is not covering. Hence SQL has to lookup to the cluster/heap (bookmark lookup) 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

    June 23, 2009 at 2:01 pm

    #1014243

  • RE: Newbie: Database health, transaction log size, dbcc SHRINKDATABASE, best practise etc

    Set the log to a size that it needs to be for the volume of transactions and frequency of log backups and then leave it alone. Repeated shrink/grow 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

    June 23, 2009 at 1:57 pm

    #1014240

  • RE: sys.dm_db_missing_index_details

    Lynn Pettis (6/23/2009)

    I've had it suggest that I include over half of the columns from the table and that just doesn't make sense to me as that would make 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

    June 23, 2009 at 9:38 am

    #1014046

  • RE: Newbie: Database health, transaction log size, dbcc SHRINKDATABASE, best practise etc

    will (6/23/2009)

    What does the 'restrict file growth' do if you set it to 10mb for a transaction log? Would it not let the log file go over 10mb?

    Correct, 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

    June 23, 2009 at 9:36 am

    #1014044

  • RE: Primary Instance Name must match Server Name ?

    If you're talking about the default instance, then it's 'name' is the server's name. With named instances you can specify the instance name, but the base is still the server'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

    June 23, 2009 at 9:24 am

    #1014032

  • RE: Newbie: Database health, transaction log size, dbcc SHRINKDATABASE, best practise etc

    will (6/23/2009)

    However some of my questions still remain..

    Specifically....

    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

    June 23, 2009 at 9:10 am

    #1014026

  • RE: Shrinking Log Files

    sarvesh singh (6/23/2009)

    BACKUP LOG with truncate_only

    Deprecated in SQL 2005, gone in SQL 2008.

    Oh, and the full backup goes after the log truncation. If you do it before then the 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

    June 23, 2009 at 8:58 am

    #1014013

  • RE: Shrinking Log Files

    HDMan (6/23/2009)

    Thanks, Gail. I read through it, and I understand what the log is and how it's used. But that failed to answer my question. Basically, of...

    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

    June 23, 2009 at 8:56 am

    #1014010

  • RE: Not able to create sp

    kiranjanga2 (6/23/2009)

    Can u pls edit this sp for running in sqlserver2000.

    Thanks in advance.

    Why don't you tell us what errors and what lines, and we'll advice you on resolving them.

    Personally,...

    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

    June 23, 2009 at 8:38 am

    #1013993

  • RE: Shrinking Log Files

    Please read through this - Managing Transaction Logs[/url]

    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

    June 23, 2009 at 8:36 am

    #1013990

  • RE: Tlog space can't be reused

    nscott (6/23/2009)

    Thanks for your help! The field in question contains a value of "LOG_BACKUP". As mentioned above, I have performed full backups of the transaction log, with no...

    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

    June 23, 2009 at 7:56 am

    #1013948

  • RE: Slow performance query with subquery

    Then please do a statistics update, preferably with full scan. I wasn't asking to remove fragmentation, an index rebuild updates stats and, from what I can see, stats are way...

    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

    June 23, 2009 at 6:54 am

    #1013882

  • RE: Common questions asked in SQL Server DBA Interview

    jcrawf02 (6/23/2009)

    I think it's important to know these concepts so that you don't have to worry about how rigorous your cases are, because if you don't test for that situation,...

    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

    June 23, 2009 at 6:32 am

    #1013866

  • RE: Forum best practice - quoting code

    Tom Brown (6/23/2009)

    SELECT

    'blank line above',

    'and below'

    above gives me some IE errors in preview - but preserves the blank lines

    (syntax highlighter can't find brush for 'noncode')

    And in Firefox gives those errors...

    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

    June 23, 2009 at 6:23 am

    #1013861

  • RE: RE-CONFIGURE SQL Server

    Since you're formatting you'll have to reinstall SQL, so no changes will be necessary.

    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

    June 23, 2009 at 6:05 am

    #1013856

Viewing 15 posts - 38,236 through 38,250 (of 49,552 total)