Forum Replies Created

Viewing 15 posts - 41,401 through 41,415 (of 49,552 total)

  • RE: Backup transaction log file

    Niyala (1/27/2009)

    The backup job is running, even after that particular event.

    The full-backup job is going perfectly well

    Do you have transaction log backups?

    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

    January 27, 2009 at 3:56 am

    #933081

  • RE: How to manage mdf and lfd files 4 performance

    There is absolutely no reason to have multiple log files. It gains you nothing. Log files are written in sequence, not in parallel. The only reason to have more than...

    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

    January 27, 2009 at 3:55 am

    #933080

  • RE: MCTS and next step

    Parthipan (1/27/2009)

    Please inform me, how can I take beta exam of 70-432 MCTS SQL 2008.

    All of the 2008 exams are out of beta. Hence there's no way for you 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

    January 27, 2009 at 3:51 am

    #933079

  • RE: Date stored as a Decimal

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic643933-338-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

    January 27, 2009 at 12:18 am

    #933024

  • RE: Defragmentation of Indexes on SQL 2005 Sharepoint Database

    Make sure there's no shrink operation running, autoshrink or a scheduled shrink.

    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

    January 27, 2009 at 12:09 am

    #933018

  • RE: Keeping user database in memory

    serge.kovacs (1/26/2009)

    Maybe I wasn't clear on the inner workings of the application on start-up. It will load all data from all tables so there should be no need to use...

    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

    January 26, 2009 at 11:57 pm

    #933015

  • RE: Urgent HELP ME¡¡¡¡¡¡ Some one

    clperez271172 (1/26/2009)

    PLEASE HELP , IS URGENT , I REALY HAVE TROUBLES.

    Please don't shout (type in all caps). It's not going to make someone help you faster. If I may suggest,...

    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

    January 26, 2009 at 11:55 pm

    #933013

  • RE: Maximum index size?

    David.Poole (1/26/2009)

    I heard it from one someone who specialises in data warehouses.

    Can you ask then to substantiate the statement? Either prove it with an exec plan (where a covering...

    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

    January 26, 2009 at 1:40 pm

    #932805

  • RE: How to create mulptiple secondary data and log filegroups??????

    madhu.arda (1/26/2009)

    How this will effect sharepoint databases? if anything happens, will MS support us? and they said rebuild index task is corrected in SP2, that means if we have SP2...

    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

    January 26, 2009 at 12:37 pm

    #932782

  • RE: Weekly DB Maintenance - DBREINDEX

    I just wanted to emphasise the fragmented indexes that it would cause.

    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

    January 26, 2009 at 12:28 pm

    #932777

  • RE: How can I INSERT INTO VALUES for a table with a primary key

    Since the PK column is not declared as identity, you'll need to specify the values for the ID column. That's what it's complaining about, not the 'John Doe' name.

    As 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

    January 26, 2009 at 11:56 am

    #932763

  • RE: Are the posted answers getting worse?

    Jeff Moden (1/26/2009)

    Doesn't look like they fixed then in 2k8 and I'd be real surprised (and happy) if they actually fixed them in 2011. Seems like they're spending...

    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

    January 26, 2009 at 11:51 am

    #932758

  • RE: How to create mulptiple secondary data and log filegroups??????

    madhu.arda (1/26/2009)

    when the large mdf file is corrupted, we will lose all the data. If we have multiple file, if one of the filees is corrupted, then we have a...

    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

    January 26, 2009 at 11:49 am

    #932756

  • RE: database backups fail with BackupIoRequest::WaitForIoCompletion: read failure on backup device

    llokshin (1/26/2009)

    But in your opinion there is no way to repair the drive?

    No idea. I know databases, not drives

    That said, from those errors it appears that you have one...

    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

    January 26, 2009 at 11:43 am

    #932753

  • RE: Newbie:Why is select doing a table scan?

    If that table is frequently inserted into, then I'd suggest put the cluster on the identity, even if it's never used. That way the cluster will organise the table 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

    January 26, 2009 at 11:20 am

    #932737

Viewing 15 posts - 41,401 through 41,415 (of 49,552 total)