Forum Replies Created

Viewing 15 posts - 43,306 through 43,320 (of 49,552 total)

  • RE: Alter index is hanging

    cxpacket is a parallel skew. Drop the maxdop down and see if it helps

    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

    November 5, 2008 at 10:26 am

    #894409

  • RE: Problem with decryption

    sg (11/5/2008)

    My question is, how safe is the encrypted data, since we can easily decrypt it once we know the Symmetric Key and the Certificate?

    Or is it not as simple...

    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

    November 5, 2008 at 10:20 am

    #894403

  • RE: Scheduled Job for DBCC UPDATEUSAGE

    Why are you running update usage nightly?

    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

    November 5, 2008 at 10:18 am

    #894402

  • RE: Mitigatng Circumstances for a Heap ?

    Simon_L (11/5/2008)

    a temporary dumping ground that was written to far more than it was read from for example ?

    Something that's written to frequently is a bad candidate for...

    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

    November 5, 2008 at 10:16 am

    #894401

  • RE: How's the IT job (DBA/database developer) market ?

    Loner (11/5/2008)

    How is the job market in your area?

    Disparately short of good people, and not-so-good people for that matter. There's a massive shortage of skills in many ares 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

    November 5, 2008 at 10:12 am

    #894392

  • RE: Defragmentation in 2005 vs 2000

    DBADave (11/5/2008)

    Thanks Gail. Do they recommend rebuilding a HEAP in 2005 so the table stats get updated or is something else being done to the HEAP?

    It's not possible 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

    November 5, 2008 at 10:11 am

    #894390

  • RE: Can any one tell about free ebook location of 70-443 exam and book also for home .One more confusion I have whether I should do first 70-441 or 70-443.

    In addition to what John said, providing, requesting or using braindumps can result in all of your certifications been revoked, permanently. In addition, providing links to copyrighted material is not...

    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

    November 5, 2008 at 10:01 am

    #894378

  • RE: Defragmentation in 2005 vs 2000

    DBADave (11/5/2008)

    I just began experimenting with online rebuilds yesterday and was surprised by how well it worked. It defragmented indexes just as good as an off-line rebuild.

    Sure....

    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

    November 5, 2008 at 9:57 am

    #894373

  • RE: How to optimize my store procedure?

    Leo (11/4/2008)

    This is Test Table so that no indexes.

    I will going to do it on proper Table with indexes on when that Update process is okay.

    You should put indexes...

    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

    November 5, 2008 at 9:54 am

    #894370

  • RE: How actually the restore works?

    Mani (11/5/2008)

    So, if log backups run every 1hr and database crashed at 10:59am. That means whatever the activity happened between 10:00am to 10:59am will exist in ldf file.If We 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

    November 5, 2008 at 1:02 am

    #894078

  • RE: How actually the restore works?

    Mani (11/4/2008)

    As you said that The log records contained in the backup will be replayed against the database.Here I did not understand 'replayed'against the database?

    niether replace nor append is fine...

    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

    November 5, 2008 at 12:10 am

    #894072

  • RE: Managing Transaction Logs

    Anirban Paul (11/4/2008)

    When will that book will be published? Please inform us. 🙂

    I don't know yet. Also, not sure how much I'm supposed to say about it.

    I'm only writing...

    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

    November 5, 2008 at 12:06 am

    #894071

  • RE: Database in recovery mode

    balbirsinghsodhi (11/4/2008)

    It did not say anything other than blocking. Let's say if you cannot connect sql server then how should we trouble shoot the issue. where to look for 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

    November 4, 2008 at 11:58 pm

    #894070

  • RE: Defragmentation in 2005 vs 2000

    DBADave (11/4/2008)

    I think people use different terms for external fragmentation. It occurs when extents are not contiguous. Check out these links for a better explanation.

    Extent fragmentation is what...

    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

    November 4, 2008 at 11:57 pm

    #894069

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    Jayakumar Krishnan (11/4/2008)

    The CHECKDB executed and there is no consistency errors on the DB.

    That's good! It may be that the backup was damaged, or it may be that the destination...

    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

    November 4, 2008 at 11:53 pm

    #894068

Viewing 15 posts - 43,306 through 43,320 (of 49,552 total)