Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Query Analyzer - Execution Time

    Be sure to run "CHECKPOINT" before dropping the cleanbuffers.  Otherwise it may not have the desired effect.

  • RE: MSDb reverts to Simple recovery model

    It sounds like we have two choices:

    - Give in to MSFT.  Do only simple backups of msdb.

    - Set msdb to full recovery mode before each transaction log backup

     

    I am tempted...

  • RE: unusual sysprocesses results

    We're having the same problem with a server:

     

    2004-10-20 16:09:10.47 server    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)

     Dec 17 2002 14:22:05

     Copyright (c) 1988-2003 Microsoft Corporation

     Enterprise Edition on Windows...

  • RE: SYSPROCESSES - Anybody has a clue?

    Milo,

    Did you get anywhere?  We are having this identical problem on our servers.

    Same version of OS you have installed on the server.

    SQL Enterprise Server Edition.

    2004-10-20 16:09:10.47 server    Microsoft SQL Server ...

  • RE: DBCC Showcontig results

    Did you solve the DBCC SHOWCONTIG problem?

    I've been working on getting DBCC SHOWCONTIG for every database in the server for the last day.

    Problem #1: Getting DBCC SHOWCONTIG to execute in...

  • RE: DBCC SHOWCONTIG returns no results

    >>Have you done a dbcc checktable?

    It passed.  And I discovered this instance of the table had 0 rows.

    I inserted one row and DBCC SHOWCONTIG worked.

    Mystery solved: 0 row tables do...

  • RE: DBCC SHOWCONTIG returns no results

    Yes: DBCC SHOWCONTIG ('TRANSACTIONS') with all_indexes did not return any results.

    No variant of it returned results for this table (and some other tables in my database).  The only noticeable similarity...

Viewing 7 posts - 1 through 7 (of 7 total)