Forum Replies Created

Viewing 15 posts - 27,091 through 27,105 (of 49,552 total)

  • RE: Sql server 2005 Mdf File Shrinking on Windows environment

    DBCC ShrinkDatabase or DBCC shrinkFile are the only ways to shrink a database (other than autoshrink which should never, never, never be enabled)

    A restore always recreates the database exactly as...

    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

    March 25, 2011 at 5:49 am

    #1303499

  • RE: Blocked process is attempting to [create procedure sys.sp_sproc_columns...]

    Any time you look at the sql_text for a session that's running a stored procedure (any stored procedure, user or system), you will get the create procedure statement 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

    March 25, 2011 at 5:47 am

    #1303497

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

    vamshikrishnaeee (3/25/2011)

    I have moved the data from the corrupted database to the new database. Will the new database get corrupted because of importing data from the corrupted database because might...

    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

    March 25, 2011 at 5:43 am

    #1303495

  • RE: database performance

    Most of the 3rd party monitoring tools should be able to give you some of that at lease. Get demos of them and try them out, see which work best...

    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

    March 25, 2011 at 4:36 am

    #1303469

  • RE: Restore - too recent to apply to the database?

    That's not what I meant. All I can see is a 'domain unregistered' error image.

    Edit your post. Go to the section below the edit box. Click Edit Attachements. Click...

    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

    March 25, 2011 at 4:32 am

    #1303466

  • RE: Restore - too recent to apply to the database?

    Please attach the image to your post. Below the edit box there's an 'Edit Attachements' button.

    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

    March 25, 2011 at 4:14 am

    #1303457

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/25/2011)

    That's not fair. You owe me a copy of your book.

    What book? <innocent look>

    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

    March 25, 2011 at 3:15 am

    #1303432

  • RE: Changing IDENTITY column of a huge table from INT to BIGINT - is there a way without recreating the entire table?

    Err, don't know. Test it.

    Otherwise, add a new bigint column, update it with the identity values, drop the int column then alter the bigint to be identity (iirc that works,...

    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

    March 25, 2011 at 3:07 am

    #1303427

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/25/2011)

    Couldn't resist....

    AHHHHHHH!!!!! You beat me of a couple of seconds!!!

    That's cause I cheated. Hit quote and post, then went back and added something meaningful. 😀

    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

    March 25, 2011 at 3:05 am

    #1303425

  • RE: Are the posted questions getting worse?

    GilaMonster (3/25/2011)

    ... and the chapter for the book project ....

    Hmmm, am i supposed to talk about that yet???

    (0)!

    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

    March 25, 2011 at 3:01 am

    #1303422

  • RE: Are the posted questions getting worse?

    Ok, time to hit that Support Doc. The quicker i get started, the quicker I can get more boring crap thrown my way.

    Between a blog post and the chapter for...

    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

    March 25, 2011 at 2:58 am

    #1303420

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/25/2011)

    Maybe a blog post that Microsoft has purchased MySQL from Oracle and that it is integrating it with SQLServer.\

    I like that....

    Edit: The index maintenance suggestion gives me ideas...

    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

    March 25, 2011 at 2:57 am

    #1303418

  • RE: Are the posted questions getting worse?

    Oh, forgot to mention. (7)

    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

    March 25, 2011 at 2:45 am

    #1303412

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/25/2011)

    GilaMonster (3/25/2011)

    Gianluca Sartori (3/25/2011)

    THE THREAD could be a great source of inspiration, but would spoil the joke for all the threadizens...

    (13)

    As long as no one goes off 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

    March 25, 2011 at 2:44 am

    #1303411

  • RE: Is my Database consistent after running DBCC CHECKDB with ALLOW_DATA_LOSS

    The error you gave does not mean the log is corrupt. Could be that the log and data file don't match, could be other causes too

    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

    March 25, 2011 at 2:32 am

    #1303405

Viewing 15 posts - 27,091 through 27,105 (of 49,552 total)