Forum Replies Created

Viewing 15 posts - 37,531 through 37,545 (of 49,552 total)

  • RE: Can't backup transaction log in Sql Server 2000

    Great, now please read through this - Managing Transaction Logs[/url]

    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

    July 21, 2009 at 5:58 am

    #1027539

  • RE: Table design

    You can split them out if you want, up to you. If you chose to do so, just replace the AssessmentHeading column with an assessmentHeadingID and have another table like...

    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

    July 21, 2009 at 5:55 am

    #1027537

  • RE: Issue with reorganizing and rebuilding indexes

    You can kill the shrink, it's not harmful to do so and it'll kill fairly quickly. However we need to find what's running that shrink and remove it.

    Do you have...

    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

    July 21, 2009 at 5:54 am

    #1027535

  • RE: Can't backup transaction log in Sql Server 2000

    What recovery model is your database in? I'm guessing simple. Logs can only be backed up if the DB is in full or bulk-logged recovery.

    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

    July 21, 2009 at 2:58 am

    #1027465

  • RE: data corruption

    CheckDB won't repair these, they're damaged statsblobs in sysindexes. There's a chance that we can repair them manually, if it doesn't work, you're going to have to either restore from...

    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

    July 21, 2009 at 2:55 am

    #1027464

  • RE: Issue with reorganizing and rebuilding indexes

    rvje (7/21/2009)

    None of them seems to be disabled. I found another thing that strikes me as odd though. In the treeview (the left pane) in management studio, I see 10...

    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

    July 21, 2009 at 2:08 am

    #1027449

  • RE: ORDER BY [DATE] producing unordered result

    Can you post the entire query?

    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

    July 21, 2009 at 2:02 am

    #1027445

  • RE: Deadlocks occuring during insert

    Be patient. You posted that just before 5pm my time yesterday. I'll take a look when I have several minutes to spend on it exclusively.

    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

    July 21, 2009 at 2:02 am

    #1027444

  • RE: data corruption

    Can you run the following and post the full results?

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

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/

    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

    July 21, 2009 at 1:57 am

    #1027441

  • RE: Table design

    awp (7/20/2009)

    One more thing, I calculated roughly around 600000 records mey be created in the 'StudentAssessmentMarks' table, that is about 3 million records in 5 years time. I am wondering...

    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

    July 21, 2009 at 1:50 am

    #1027439

  • RE: how to reduce tempdb size in production in ms sql

    Before you shrink tempDB, read through this: http://support.microsoft.com/kb/307487

    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

    July 20, 2009 at 1:59 pm

    #1027276

  • RE: Replication with Simple Revover Model

    mahesh.vsp (7/20/2009)

    upto my knowledge, in SIMPLE recovery model, the T-log gets truncated whenever CKPT occurs or whenever 70% of the T-log is full.

    How would this allow replication in Simple model?????????

    http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/

    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

    July 20, 2009 at 1:56 pm

    #1027274

  • RE: PASS or Class?

    I suspect I know who's teaching it (will PM you). If it is the class will be awesome. Regarding PASS, you can buy the DVD even if you don't attend...

    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

    July 20, 2009 at 1:44 pm

    #1027269

  • RE: Issue with reorganizing and rebuilding indexes

    rvje (7/20/2009)

    They seem rather small, about 2-60 pages.

    Due to the way pages are allocated for small indexes/tables, very small indexes don't defrag properly. It's not a concern. Fragmentation only starts...

    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

    July 20, 2009 at 1:42 pm

    #1027267

  • RE: What is the Use of On-Line Off-Line in ms sql.

    If the question was urgent (as you stated), you should have checked Books Online. It's faster than waiting for someone to reply.

    Books Online:

    OFFLINE

    The database is closed, shut down cleanly, 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

    July 20, 2009 at 10:01 am

    #1027107

Viewing 15 posts - 37,531 through 37,545 (of 49,552 total)