Forum Replies Created

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

  • RE: OPtimization Skills

    rohit11.jagannath (4/24/2013)

    2) Removal of unused variables

    Code cleanup, not much to do with optimisation

    4) Replacement of multiple 'Set' statements with a single select statement.

    That's more a style decision than anything else...

    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

    April 24, 2013 at 5:47 am

    #1609421

  • RE: Read transaction log file

    Simple recovery = log truncated on checkpoint, meaning it'll get overwritten when the log wraps around.

    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

    April 24, 2013 at 5:18 am

    #1609411

  • RE: Read transaction log file

    Hang on, if the database that the delete was run on was in simple recovery model, why did you tell me it was in full recovery?

    When restoring a database, all...

    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

    April 24, 2013 at 4:46 am

    #1609401

  • RE: Troubleshoot Msg 824 in SQL Server

    saidapurs (4/24/2013)

    Hi GilaMaster,

    Sorry, i have updated allocation error for my privies comment and consistency purpose below command can use..

    use master

    go

    alter database DBname set...

    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

    April 24, 2013 at 4:29 am

    #1609395

  • RE: backup in Logshipping

    Yes.

    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

    April 24, 2013 at 3:33 am

    #1609375

  • RE: Restoring System Databases

    Yes, rebuild the system DBs sets them all back to default and you will need to restore all three backups later, and the process to restore system databases is documented...

    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

    April 24, 2013 at 3:29 am

    #1609373

  • RE: Read transaction log file

    Can you not just take a log backup (or take the regular log backups), restore the lastest full to a new DB, restore all the logs and STOPAT just before...

    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

    April 24, 2013 at 3:20 am

    #1609371

  • RE: Log backups while Full/Differential backups are running

    pdanes (4/23/2013)

    I assume then, that the reading of log records is a one-time event? That is, after doing the primary read, it catches up with the log records once, 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

    April 24, 2013 at 3:15 am

    #1609370

  • RE: Pratical Advantage of Heap

    Not many. It may give slightly faster inserts but there's enough downsides that it;s not usually a good idea. Unless you've tested and know that a heap is faster 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

    April 24, 2013 at 3:10 am

    #1609369

  • RE: Troubleshoot Msg 824 in SQL Server

    saidapurs (4/24/2013)

    Use the below command for consistency errors..

    DBcc updateusage(BDname, "Tablename")

    Nope, completely useless.

    The only thing that will fix is incorrect space used information. Run that on...

    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

    April 24, 2013 at 3:05 am

    #1609367

  • RE: Restoring System Databases

    Did you read the article I referenced?

    At this point, it may be easier to rebuild the system tables and then restore master, model and msdb.

    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

    April 24, 2013 at 3:03 am

    #1609366

  • RE: Read transaction log file

    What recovery model?

    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

    April 24, 2013 at 12:13 am

    #1609340

  • RE: Restoring System Databases

    Have a read through this, see if it helps

    https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    It may be easier to just rebuild the system databases then restore the backups after.

    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

    April 24, 2013 at 12:00 am

    #1609336

  • RE: Locks on tempdb objects

    Eugene Davydov (4/23/2013)

    I said that information: c# code calls in loop some simple procedures which perfoms only atomic insert/update/delete (by one row). There's no reason for escalation. More loop amount,...

    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

    April 23, 2013 at 3:37 pm

    #1609287

  • RE: Locks on tempdb objects

    Eugene Davydov (4/23/2013)

    GilaMonster (4/23/2013)

    I think a lot more information is needed to say anything useful. Oh, except for the fact that changing temp tables to table variables will do nothing...

    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

    April 23, 2013 at 2:24 pm

    #1609265

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