Forum Replies Created

Viewing 15 posts - 21,766 through 21,780 (of 49,552 total)

  • RE: spreading nc index over more than 1 file

    Not without writing half a book. There are a lot of factors involved including:

    Whether the DB is IO bottlenecked (and if so, where in the IO subsystem the bottleneck is)

    Access...

    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

    December 12, 2011 at 8:52 am

    #1420127

  • RE: spreading nc index over more than 1 file

    It would be spread across both.

    There may be a performance benefit (or may 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

    December 12, 2011 at 8:36 am

    #1420109

  • RE: Delete Old Transaction Log files?

    Personally I like keeping log backups that cover 2 full backups. That way, if there's anything wrong with the latest, it's possible to go back to the oldest.

    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

    December 12, 2011 at 8:36 am

    #1420106

  • RE: Evaluating Index Usage for Index Maintenance Script

    Determining if an index is in use is a lot more complex than it might appear.

    The index usage stats are only since the last start of the database, so if...

    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

    December 12, 2011 at 8:03 am

    #1420090

  • RE: Indexing in sql server 2008R2 versus sql server 2005

    GilaMonster (12/12/2011)

    How big is the index in question? How much free space in the files belonging to 'Data Filegroup 1'?

    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

    December 12, 2011 at 7:58 am

    #1420087

  • RE: Backup strategy for point in time recovery

    Paula-196779 (12/12/2011)

    1. Am I right in thinking that it will not really be possible to do point in time recovery unless the transaction log backups run far more frequently...

    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

    December 12, 2011 at 7:26 am

    #1420072

  • RE: Restoring a TL that returns error "logical consistency-based I/O error" ?

    imtiazm (12/12/2011)

    So my question:

    1) Can i restore past the point of error in the transaction log file. ignoring the error)

    2) Can i restore just before the point of error....

    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

    December 12, 2011 at 6:51 am

    #1420051

  • RE: SQL server database last refresh date and time - how to check?

    ashanair70 (12/12/2011)

    We create test database from a backup copy of production database every weekend. I want to find out whether there is a way I can find the last refresh/restore...

    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

    December 12, 2011 at 6:43 am

    #1420041

  • RE: Restoring a TL that returns error "logical consistency-based I/O error" ?

    Yes. I understood your explanation.

    I suspect that the full backup has the corruption in it. Unless the backup was taken WITH CHECKSUM, corruption will not cause the backup to fail,...

    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

    December 12, 2011 at 6:21 am

    #1420022

  • RE: Trigger to update and inser a count in column

    Google?

    If you want our help, post the table DDL and the current trigger code at the very least.

    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

    December 12, 2011 at 6:17 am

    #1420017

  • RE: my dbcc checkdb is getting failed

    10GB? That's not a good idea. Not just because of CheckDB, but that's an insanely small size for TempDB on a production server for normal usage.

    Move TempDB's data file 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

    December 12, 2011 at 6:15 am

    #1420015

  • RE: Restoring a TL that returns error "logical consistency-based I/O error" ?

    Could well be that the full backup you used is damaged. The log restore hits the corruption and breaks.

    Can your restore just that full backup (restore it WITH RECOVERY) 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

    December 12, 2011 at 6:13 am

    #1420011

  • RE: my dbcc checkdb is getting failed

    No. Normal checkDB. Shouldn't take long on a 300GB.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    December 12, 2011 at 6:11 am

    #1420007

  • RE: tempdb file placement

    Dev (12/12/2011)

    Jeff Moden (12/12/2011)

    Dev (12/12/2011)

    per BOL:

    If data must be quickly recoverable, consider mirroring the transaction log and putting the database on a RAID 5 disk. RAID...

    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

    December 12, 2011 at 6:05 am

    #1420003

  • RE: tempdb file placement

    2Tall (12/12/2011)

    Hi. I have a SAN with virtual arrays striped across all spindles. I have presented 2 * RAID 1 LUN's to SQL for tempdb placement. I have placed...

    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

    December 12, 2011 at 6:03 am

    #1419998

Viewing 15 posts - 21,766 through 21,780 (of 49,552 total)