Forum Replies Created

Viewing 15 posts - 27,406 through 27,420 (of 49,552 total)

  • RE: Why Sql Server fails to use index?

    Is ID the only primary key column? Is it clustered?

    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

    March 12, 2011 at 1:39 pm

    #1298038

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/12/2011)

    Grant Fritchey (3/12/2011)

    GilaMonster (3/12/2011)

    Anyone got any suggestions for here: http://www.sqlservercentral.com/Forums/Topic1077027-392-1.aspx

    took a stab at it.

    Posted how to inspect the text using substring() and tally table, I've been having to 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

    March 12, 2011 at 6:40 am

    #1298005

  • RE: Database Restore Never Finishes

    Jeffrey Williams-493691 (3/12/2011)

    In your code - you are not specifying RECOVERY which tells SQL Server to finish the backup and recover the database.

    With RECOVERY is the default if nothing is...

    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

    March 12, 2011 at 3:53 am

    #1297991

  • RE: Are the posted questions getting worse?

    Anyone got any suggestions for here: http://www.sqlservercentral.com/Forums/Topic1077027-392-1.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

    March 12, 2011 at 3:51 am

    #1297990

  • RE: mirroring and clustering

    crainlee2 (3/11/2011)

    GilaMonster (3/11/2011)....One thing with a cluster is that it has a single point of failure - the drives

    Yes, the Quorum and the MSDTC drives.

    The database drives themselves, unless 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

    March 12, 2011 at 3:49 am

    #1297989

  • RE: Are the posted questions getting worse?

    I signed off two official design documents back at the bank as "Database Overlord". No one commented.

    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

    March 11, 2011 at 11:08 am

    #1297798

  • RE: join data on strings

    The space and hyphen will not give trouble if they are the same in both. Are you absolutely sure that the data is exactly the same, no leading spaces case...

    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

    March 11, 2011 at 10:31 am

    #1297777

  • RE: Recovery model in SQL Server 2005

    [Jim].[dba].[Murphy] (3/11/2011)

    GilaMonster (3/11/2011)

    In bulk logged you can restore to point in time unless there was a minimally logged operation during the period covered by that log backup. If there is,...

    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

    March 11, 2011 at 8:59 am

    #1297707

  • RE: mirroring and clustering

    scott_lotus (3/11/2011)

    Sorry struggling to get a chance to reply to this in as much detail as i would like. We do have many open connections , some legacy apps that...

    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

    March 11, 2011 at 8:54 am

    #1297701

  • RE: mirroring and clustering

    belucey (3/11/2011)

    The issue had nothing to do with clustering. The problem was with unclosed conversations within service broker. We had millions, we found SQL had to cycle through all 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

    March 11, 2011 at 6:23 am

    #1297577

  • RE: Max Memory

    My desktop (at 8GB) has as much or more memory as any of the servers at my current client. Most I've ever seen was at one of the banks -...

    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

    March 11, 2011 at 6:22 am

    #1297576

  • RE: LOB Data

    Working on demos and presentation for 24 hours of pass. Weekend, what weekend?

    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

    March 11, 2011 at 5:16 am

    #1297546

  • RE: Recovery model in SQL Server 2005

    beejug1983 (3/11/2011)

    guys, if everything gets logged in log file in Simple and Bulk Logged recovery then why we are not able to restore point in time recovery.

    In simple because 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

    March 11, 2011 at 4:55 am

    #1297537

  • RE: REPLICATION FOR SQL2008

    Transactional replication

    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

    March 11, 2011 at 4:51 am

    #1297535

  • RE: Avoiding Logging

    [Jim].[dba].[Murphy] (3/10/2011)

    Gail - right; exactly the side effects I was talking about. I didn't mean to allude to data getting damaged

    Cool. There's just so many myths and so much...

    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

    March 10, 2011 at 12:53 pm

    #1297329

Viewing 15 posts - 27,406 through 27,420 (of 49,552 total)