Forum Replies Created

Viewing 15 posts - 19,336 through 19,350 (of 49,552 total)

  • RE: bad performance quary

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 5, 2012 at 6:30 am

    #1469453

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (4/5/2012)

    I wonder if log shipping is an option to a db setup for auditing.

    Hands tied, feet tied, and blindfolded.

    Mouth is not taped, so at least you can scream.

    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

    April 5, 2012 at 6:28 am

    #1469448

  • RE: Backup Database with Stop at command

    chetanr.jain (4/5/2012)

    Nope..

    It allowes me to user STOP AT command in Full database restore.

    However, it allowes me to specify the time between only when full backup started and completed.

    Yes, but 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

    April 5, 2012 at 6:26 am

    #1469446

  • RE: DBCC Question

    dfrome (4/4/2012)

    Yes, that's true, but i already knew how to fix it. Just wondering why they appeared and disappeared and i didn't drop/create. The only other thing that happened was...

    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 5, 2012 at 6:10 am

    #1469439

  • RE: DBCC Question

    Lynn Pettis (4/4/2012)

    Looking at the errors, isn't the corruption reported in a nonclustered index (index_id = 2), and that if you drop and recreate the nonclustered index wouldn't that fix...

    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 5, 2012 at 6:04 am

    #1469434

  • RE: Transaction Log Shipping Question

    MysteryJimbo (4/5/2012)

    GilaMonster (4/4/2012)

    1. Yes, but it's not very useful. If the primary ever fails and you have to switch to the secondary, there will be no way to go back...

    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 5, 2012 at 6:01 am

    #1469433

  • RE: Reading data from the Transaction Log?

    Ninja's_RGR'us (4/4/2012)

    That handles deletions, but it can be adapted for anything else.

    I've never tested it so I can't garantee how good it works.

    http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/

    Jeff raised that last time. Yes, it's possible....

    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 5, 2012 at 6:00 am

    #1469432

  • RE: Are the posted questions getting worse?

    Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-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

    April 4, 2012 at 5:26 pm

    #1469230

  • RE: Reading data from the Transaction Log?

    p.s. Have you considered extended events?

    Edit: or query notifications.

    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 4, 2012 at 5:16 pm

    #1469225

  • RE: Transaction log records for a table

    The begin and end are tracked by the LOP_BEGIN_XACT and (I believe) by the matching commit or rollback. So look for the begin tran and commit log records that match...

    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 4, 2012 at 5:15 pm

    #1469223

  • RE: Reading data from the Transaction Log?

    peter 82125 (4/4/2012)

    Thanks for the reply. CDC changes the database by adding tables. That's not an option on this project.

    Why not? What about change tracking? SQLAudit?

    We had this discussion...

    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 4, 2012 at 5:11 pm

    #1469222

  • RE: DBCC Question

    dfrome (4/4/2012)

    My question is now that DBCC comes back clean, I know there's still corruption somewhere in there and it's just a matter of time before SQL reallocates to 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

    April 4, 2012 at 4:49 pm

    #1469219

  • RE: Reading data from the Transaction Log?

    There are log readers. ApexSQL is one, can't recall the other. They're both about $1000/license.

    Any reason you can't use CDC or Change Tracking?

    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 4, 2012 at 4:43 pm

    #1469218

  • RE: Point in Time recovery of data between times

    Yes, that will get you back anything deleted after '2012-04-04 14:00:39.000'

    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 4, 2012 at 2:51 pm

    #1469181

  • RE: SQL jobs Dead Locks Issue

    Select * from msdb..sysjobs where CONVERT(BINARY(16), job_id) = 0xD78FB44BE950344EB5F48F457FD1227B

    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 4, 2012 at 12:49 pm

    #1469106

Viewing 15 posts - 19,336 through 19,350 (of 49,552 total)