Forum Replies Created

Viewing 15 posts - 25,351 through 25,365 (of 49,552 total)

  • RE: Database Mirroring

    😛

    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 24, 2011 at 2:45 pm

    #1343929

  • RE: Database Mirroring

    tnk7200 (6/24/2011)

    Well, I just joined SSC, and answered first question correct. It's a basic question, but I notice only about 57% people got this right. So, it's not easy 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

    June 24, 2011 at 2:26 pm

    #1343921

  • RE: Database Mirroring

    SQLRNNR (6/24/2011)

    I don't get it? Are you sure about that?

    What are you not sure about?

    I didn't pick the points, I think I'd have made this 1 point and it'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 24, 2011 at 2:24 pm

    #1343919

  • RE: not restarting the instance of a database the transactions log will be full?

    Please read through this: http://www.sqlservercentral.com/articles/64582/

    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 24, 2011 at 12:58 am

    #1343487

  • RE: kindly give some solution

    Poor performance, but due to row size (and resultant index depth). All other things being equal (index key, insert pattern), the varchar is more prone to page splits than 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 24, 2011 at 12:55 am

    #1343485

  • RE: Tail Log Backup in SQL Server 2005

    You need NO_TRUNCATE for a tail log backup with a damaged mdf (is documented), but won't help here, something broke the log chain before this point (switch to simple recovery...

    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 24, 2011 at 12:40 am

    #1343477

  • RE: Database Mirroring

    bitbucket-25253 (6/23/2011)

    A rather obvious answer. Come on Gail make your next QOD more difficult.

    Wait a week.

    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 24, 2011 at 12:37 am

    #1343476

  • RE: Deadlocking advice on a frequently rebuilt reporting table

    CarpenterBob (6/23/2011)

    How about READ UNCOMMITED to avoid locks...

    How about one of the snapshot isolation levels to avoid locks other than write locks?

    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, 2011 at 1:53 pm

    #1343370

  • RE: kindly give some solution

    ankit.shukla1105 (6/23/2011)

    The question was to practically demo how char uses up more space than varchar, so here's the demo.

    I created two tables, VarChar_Table and Char_Table as below:

    create table Char_Table (name...

    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, 2011 at 1:49 pm

    #1343369

  • RE: Reverse arguments in an IN statement?

    ORs are fully SARGable, they just require a very different indexing setup than AND. http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/

    Also note that the parser/algebratiser expands IN into a series of OR before optimisation begins.

    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, 2011 at 1:47 pm

    #1343368

  • RE: Tail Log Backup in SQL Server 2005

    Steve Jones - SSC Editor (6/23/2011)

    You backup the tail of the log if you are having issues with your database and are about to restore. It's a normal log backup.

    This...

    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, 2011 at 1:46 pm

    #1343366

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/23/2011)

    Has anyone seen the Green Lantern movie yet?

    Don't think it's out in SA yet. Do want to watch it when it gets there.

    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, 2011 at 1:44 pm

    #1343364

  • RE: Tail Log Backup in SQL Server 2005

    Ninja's_RGR'us (6/23/2011)

    GilaMonster (6/23/2011)

    In this situation, there is NO way to take a log backup (the log chain is broken) so the best you can do is restore full, diff and...

    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, 2011 at 1:42 pm

    #1343361

  • RE: Which is more efficient? WHERE SUBSTRING = ...or... WHERE fldField LIKE 'x%'

    Correct.

    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, 2011 at 1:39 pm

    #1343359

  • RE: Tail Log Backup in SQL Server 2005

    In this situation, there is NO way to take a log backup (the log chain is broken) so the best you can do is restore full, diff and any 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, 2011 at 11:13 am

    #1343257

Viewing 15 posts - 25,351 through 25,365 (of 49,552 total)