Forum Replies Created

Viewing 15 posts - 39,031 through 39,045 (of 49,552 total)

  • RE: Transaction log filling up

    amina omar (1/23/2004)

    My transaction log keeps filling up, even though it's backup nightly and should be getting truncated any time it's backed up.

    Transaction log backups or database backups? Only tran...

    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

    May 18, 2009 at 2:18 pm

    #996625

  • RE: Transaction log filling up

    pradyothana (5/18/2009)

    If there is no logshpping in place, Better to truncate the log after backup.

    That is terrible advice to give, especially since you don't mention what truncate only does 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

    May 18, 2009 at 2:02 pm

    #996617

  • RE: DBCC CHECKDB resulted in error

    The error was probably a left-over from SQL 2000. If you get it again, after you've fixed it with UpdateUsage, then maybe consider calling product support.

    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

    May 18, 2009 at 1:54 pm

    #996612

  • RE: Transaction context in use by another session - SQL2005

    Please don't cross post. It just wastes peoples time and fragments replies.

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

    May 18, 2009 at 10:23 am

    #996479

  • RE: RESTORE issue

    karthikeyan (5/18/2009)

    Using this only backup file how can i restore.

    You can't.

    You have one piece of a backup. If three backup destinations are specified (either in script or in 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

    May 18, 2009 at 10:20 am

    #996475

  • RE: Whole batch insert operation killed by "Cannot insert duplicate key row in object .... unique index" violation

    monsieurmark777 (5/18/2009)

    Have checked the DBs and they all seem to be set as "French_CI_AS"...

    Any clue why I can't append your line?

    Check the server's collation (which affects the system databases), check...

    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

    May 18, 2009 at 10:14 am

    #996470

  • RE: data compression

    DNA (5/18/2009)

    You can reorganize the database using a maintenance plan or by shrinking the database in Enterprise Manager/Management Studio.

    However note that shrinking will badly fragment all indexes 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

    May 18, 2009 at 10:13 am

    #996467

  • RE: How to improve the performance of a table

    sk.panda (5/18/2009)

    Could you please suggest me what are the best possible way we can optimize the table so that we can improve the performance our application using this table?

    Good indexes...

    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

    May 18, 2009 at 7:12 am

    #996294

  • RE: Rebuild indexes in database after new disks added

    george sibbald (5/18/2009)

    Gail, stop it! give someone else a chance! 😀

    Type faster in future. 😉

    😛

    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

    May 18, 2009 at 6:34 am

    #996266

  • RE: Rebuild indexes in database after new disks added

    Index fragmentation and disk fragmentation are different things. Indexrebuild and index defrag (and the 2 SQL 2005 replacements to them) fix index fragmentation. They are neither affected by nor do...

    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

    May 18, 2009 at 6:29 am

    #996262

  • RE: List all user databases

    jensgc (5/18/2009)

    The closest I can get is to look at the "sid" column in sys.sysdatabases - where the apperant value '0x01' supposedly indicates a system database. But even if this...

    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

    May 18, 2009 at 6:23 am

    #996258

  • RE: List all user databases

    SELECT *

    FROM sys.databases

    WHERE database_id > 4

    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

    May 18, 2009 at 6:19 am

    #996254

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (5/17/2009)

    Jan Van der Eecken (5/17/2009)

    But if you are serious about donating a bat, why don't you hand it to Gail? We would surely figure out...

    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

    May 18, 2009 at 6:16 am

    #996252

  • RE: Whole batch insert operation killed by "Cannot insert duplicate key row in object .... unique index" violation

    monsieurmark777 (5/18/2009)

    The problem is the following: As the trigger sends the ten feeds to table2, if one of the batch of ten feeds violates the primary key, 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

    May 18, 2009 at 6:10 am

    #996249

  • RE: Are the posted questions getting worse?

    Tom Brown (5/15/2009)

    So you're a Brummie?

    How long did you stick around before heading off for the sun

    Yup. Family came to SA when I was 4

    Its still raining by...

    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

    May 18, 2009 at 6:02 am

    #996246

Viewing 15 posts - 39,031 through 39,045 (of 49,552 total)