Forum Replies Created

Viewing 15 posts - 30,691 through 30,705 (of 49,552 total)

  • RE: Query takes too much time

    The functions on the columns will force at least an index scan, possibly even a table scan.

    What do those UDFs 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 15, 2010 at 1:55 am

    #1221161

  • RE: Database Engine Tuning Advisor

    Not without testing and making sure the recommendations really help. Test them out one by one, implement the ones that do help.

    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 15, 2010 at 1:46 am

    #1221158

  • RE: lastwaittype as PAGEIOLATCH_SH

    As I've said more than once

    GilaMonster (9/9/2010)

    Typical solutions for this are to optimise the query so that it reads less and to evaluate the IO performance of wherever the data...

    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 15, 2010 at 1:38 am

    #1221156

  • RE: Log Backup Frequency and Max Data Loss

    SwayneBell (9/14/2010)

    When I originally read the post that I quoted in my OP, I assumed that the guideline had something to do with not being able to get at 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 14, 2010 at 12:32 pm

    #1220905

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/14/2010)

    GilaMonster (9/14/2010)

    Lynn Pettis (9/14/2010)

    The key to arguing with GilaMonster (or anyone for that matter) is:

    A) Admit when you are wrong.

    B) If not A, agree to disagree.

    And

    C) If you're...

    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 14, 2010 at 12:17 pm

    #1220902

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/14/2010)

    The key to arguing with GilaMonster (or anyone for that matter) is:

    A) Admit when you are wrong.

    B) If not A, agree to disagree.

    And

    C) If you're right, don't gloat.

    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 14, 2010 at 12:10 pm

    #1220898

  • RE: Log Backup Frequency and Max Data Loss

    SwayneBell (9/14/2010)

    Thanks Gail,

    You're one of the people I was thinking of in the postscript to my original post.

    p.s. Thank you.

    I thought you were talking about me in the main post,...

    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 14, 2010 at 11:55 am

    #1220885

  • RE: Log Backup Frequency and Max Data Loss

    SwayneBell (9/14/2010)

    So yes, barring a meteor impact or extraordinary chain of events, we can recover to the point of failure

    No, not at all.

    All that you need is for the disaster...

    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 14, 2010 at 11:54 am

    #1220884

  • RE: SQL SERVER 208 FAILOVER CLUSTERING

    george sibbald (9/14/2010)

    Ahem. The term active\active is soooooooo last year.

    I do apologist for not keeping up with fashion. 😉

    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 14, 2010 at 11:51 am

    #1220883

  • RE: Log Backup Frequency and Max Data Loss

    Depends.

    If you're doing log backups every 15 minutes and immediately archiving them to another data centre and the data file is fatally corrupted 1 minute before the next log backup,...

    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 14, 2010 at 11:29 am

    #1220867

  • RE: Extent (1:205976) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    What I'd suggest first is that you take a copy of this database, put it onto a dev/test server and then run CheckDB with the repair_allow_data_loss option. See what repairs...

    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 14, 2010 at 10:08 am

    #1220808

  • RE: SQL-Server 2005: Change Ordinal Column Position

    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

    September 14, 2010 at 9:47 am

    #1220788

  • RE: Extent (1:205976) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    Do you have any backups dating back to before 19th Aug, and is losing a month's data acceptable (note that I don't know how much you'll lose doing a repair,...

    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 14, 2010 at 9:44 am

    #1220784

  • RE: Are the posted questions getting worse?

    Anyone feel like arguing database design?

    http://www.sqlservercentral.com/Forums/Topic981529-392-1.aspx

    From that thread:

    shield_21 (9/14/2010)

    GilaMonster (9/12/2010)

    What's wrong with a properly normalised database design?

    I think using XML datatype model would be more efficient..

    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 14, 2010 at 8:30 am

    #1220729

  • RE: Extent (1:205976) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    GilaMonster (9/14/2010)

    What backups (if any) do you have from before the 19th Aug? Do you have log backups?

    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 14, 2010 at 8:29 am

    #1220723

Viewing 15 posts - 30,691 through 30,705 (of 49,552 total)