Forum Replies Created

Viewing 15 posts - 27,556 through 27,570 (of 49,552 total)

  • RE: Index requirement for logical operations

    GilaMonster (3/3/2011)

    You need two indexes because of the or

    One index on Primary, one on Secondary. You may need to make both covering, depends on the rows involved. test and see

    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 4, 2011 at 12:43 am

    #1294474

  • RE: use go inside a transaction

    Nothing to do with the transaction. You can't use GO within the TRY.

    GO is not a T-SQL command. It's a batch terminator. It marks where to break the code sent...

    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 3, 2011 at 5:17 pm

    #1294406

  • RE: Event ID 825- error reading pageID

    Caruncles (3/3/2011)

    Since I AM the team, and am not really a DBA, I took the least-invasive measure first, which was to set up a weekly defrag.

    Defrag/rebuild does not fix corruption....

    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 3, 2011 at 5:09 pm

    #1294404

  • RE: Restore - too recent to apply to the database?

    Please note that this thread is originally over 3 years old

    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 3, 2011 at 5:05 pm

    #1294403

  • RE: Difference between varchar(max) and varchar(8000)

    Please note: 2 year old thread

    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 3, 2011 at 5:04 pm

    #1294402

  • RE: Index requirement for logical operations

    You need two indexes because of the or

    One index on Primary, one on Secondary. You may need to make both covering, depends on the rows involved. test and see

    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 3, 2011 at 8:06 am

    #1294042

  • RE: if database crashes how to recover in sql server 2008

    And your log backups?

    Tail log backup requires full recovery, full recovery requires regular log backups. 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

    March 3, 2011 at 8:02 am

    #1294038

  • RE: if database crashes how to recover in sql server 2008

    Full backup every 4 hours or transaction log?

    Will your business tolerate up to 4 hours of data loss? If not, you really need to increase the frequency of the 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

    March 3, 2011 at 12:46 am

    #1293873

  • RE: Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    That's useless for fixing the problem.

    Enable traceflag 1222. That will cause SQL to write the deadlock graph into the error log when a deadlock happens. Get the deadlock graph...

    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 2, 2011 at 11:50 pm

    #1293859

  • RE: if database crashes how to recover in sql server 2008

    If you can't get SQL to start, then see 'Otherwise you will lose that data'

    You don't need to be able to connect to the DB to do a tail 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

    March 2, 2011 at 11:45 pm

    #1293858

  • RE: Is Mirroring a disaster recovery option at all ?

    Leo.Miller (3/2/2011)

    Note that Mirroring was not designed to be used in conjunction with snapshots to run reports, this is just happens to work and as far as I know 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

    March 2, 2011 at 3:51 pm

    #1293794

  • RE: Restore - too recent to apply to the database?

    Serge Mirault (3/2/2011)

    Does the fact that I've got a transaction log maintenance plan running tlog backups every 15 mins affect the log shipping?

    Yes.

    Transaction log backups form a chain....

    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 2, 2011 at 3:34 pm

    #1293779

  • RE: Odd Questions

    TravisDBA (3/2/2011)

    GilaMonster (3/2/2011)

    TravisDBA (3/2/2011)

    What if they told you the honest brutal truth and said something like "Actually, there was a hiring quota in force for this position and I'm sorry...

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

    #1293761

  • RE: Odd Questions

    TravisDBA (3/2/2011)

    What if they told you the honest brutal truth and said something like "Actually, there was a hiring quota in force for this position and I'm sorry but you...

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

    #1293719

  • RE: Rebuilding indexes in system database

    Master and model, no point. The tables in them are system databases. Msdb may be necessary, nothing wrong with rebuilding indexes on it

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

    #1293706

Viewing 15 posts - 27,556 through 27,570 (of 49,552 total)